if the
cell is greater than 0 and does not comply with condition 2 or 3

#1
If the cell is greater than 0 the first CF is applied and conditions 2 & 3
are *ignored*

I'll pass on #2

#3
CF is applied to S22
=IF(S22=$AC$5,S22)

Assuming CF 1&2 are false, CF3 is applied if S22 = AC5 and S22 when forced
to a boolean evaluates as True

Regards,
Peter T



"Paul Black" wrote in message
...
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