Formatconditional formatting, cell value greater than x

click format button and select red fonts and click OK twice

replace x with the value you want to test for


--


Regards,


Peo Sjoblom


"Dick B" wrote in message
...
I am not sure what I am doing here but my question is: I want a cell that
will receive a variable number from its formula to show the number in red
if
it exceeds a certain value. If that is to difficult than I need the cell
to
display inop or something like that

Dick B