Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting adjacent cells
I have some data in 10 columns where I want to change the data in the next
adjacent column to be coloured red if it is less or green if it is more than the current column. The next column would then need to test the previous column. I want to check simply if the number has increased or decreased from the previous figure. In Excel 2003, I managed to do this by deleting $ sign in the cell reference. Now I can't delete the $ sign. It is automatically added even when I delete it. Can you please help! -- Thanks, in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Relative to adjacent cells | Excel Discussion (Misc queries) | |||
Conditional formatting on ADJACENT Cells | Excel Discussion (Misc queries) | |||
Conditional Formatting Non-Adjacent Columns | Excel Worksheet Functions | |||
Conditional Formatting for adjacent cells | Excel Discussion (Misc queries) | |||
conditional formatting adjacent cells | Excel Worksheet Functions |