Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Hi, I hope this is the correct place to ask my question... What I want is to create a 'conditional formatting' of two colums. Example: 1|..a..|..b..| 2|..2..|..5..| 3|..5..|..5..| 4|..5..|..6..| So colum b is the result of some formulas. Colum a should be 'tested' like this: IF b a then a should be red. Unique for each row. So I used conditional format for each single row: ="$B$2 $A$2" But is it possible to create a single formula to check if the value of colum b is bigger than colum a, checking each row indepedant? Something like "$B$x $A$x" where x is the variable. So my example would be: 2: red 3: nothing 4: nothing Hope it's clear, 3Pinter -- 3Pinter ------------------------------------------------------------------------ 3Pinter's Profile: http://www.excelforum.com/member.php...o&userid=32623 View this thread: http://www.excelforum.com/showthread...hreadid=524256 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |