conditional formatting

  • Thread starter Thread starter Peter Bailey
  • Start date Start date
P

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
 
You got one reply to your first post, but another option would be to use an
adjacent cell.
 
Back
Top