For conditions 2 and 3 you will need to select Formula Is rather than
Cell Value Is in the first box in the CF dialogue, and put your
formulae in the formula box.

Hope this helps.

Pete

On Oct 16, 2:35*pm, Paul Black wrote:
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