conditional formatting

[Peter Bailey]

I have applied conditional formatting to a cell on a form that is printed on
a black and white printer so the formatting is somewhat ruined as you cannot
distinguish between the shades of grey.

If I try and use =IF(J10>=3,"Critical","Ok") it of course returns a circular
reference error as it is referring to itself.

Is there a way to achive this perhaps in VBA so that I can apply the logical
rules but return a text string.

regards in advance
Peter

 

[Debra Dalgleish]

Instead of colours, you could use a pattern from the Pattern dropdown in
the conditional formatting Patterns tab.

Or use distinctive borders for the different conditions.