Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi folks,
I have been unable to create the following conditional formatting rule for the following data: Column 1 value1 value2 value3 value 4 What I want is conditional formatting for an entire column such that a cell is coloured IF (value1/value2) exceed a certain ratio (or (value1 - value2) some other value). It needs to be the same down the whole column: ie value2/value3, value3/value4 etc. I have many columns that require this formatting but I can not figure out how to achieve it. Can anyone help? Regards, Alex |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting many rows | Excel Discussion (Misc queries) | |||
conditional formatting across rows | Excel Worksheet Functions | |||
Conditional Formatting 2 rows only | Excel Discussion (Misc queries) | |||
Conditional formatting rows | Excel Discussion (Misc queries) | |||
conditional formatting odd/even rows | Excel Programming |