Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting
Good afternoon,
I have come up against a problem regarding conditional formatting. I have this formula in cell s22 ... '=IF(OR(G22<1,G2256)," ",IF(ISERROR(HLOOKUP(G22,$B$7:$AC $8,2,0)),HLOOKUP(G22,$B$9:$AC$10,2,0),HLOOKUP(G22, $B$7:$AC$8,2,0))) .... with the cells formated as ... Font = White No Border No Pattern I have ... Condition 1 = Cell Value Is greater than 0 Font = Black Border = Outline & Pattern Colour = Grey Condition 2 = Cell Value Is equal to =IF(OR(S22=$W$5,S22=$X$5,S22=$Y $5,S22=$Z$5,S22=$AA$5,S22=$AB$5),S22) Font = Black Border = Outline & Pattern Colour = Blue Condition 3 = Cell Value Is equal to =IF(S22=$AC$5,S22) Font = Black Border = Outline & Pattern Colour = Red Condition 2 & 3 work perfectly and if the cell is a zero it shows as empty which is great. The only thing it is not doing is that if the cell is greater than 0 and does not comply with condition 2 or 3 is make the Pattern colour grey and the border outline, it does put the right figure in that you can see. Any help will be greatly appreciated. Thanks in advance, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |