cell function

[Dick B]

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

 

[Peo Sjoblom]

Format>conditional 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]

I will work with this and get back to you. I am not sure of what you sent me.
I have a cell with the formula =g62/g63 and what I want is, if that number
exceeds 103.48 I want the cell to give the result in red to alert me that I
have to change something.

 

[Peo Sjoblom]

If you click format, select conditional formatting and do as I described you
will get this functionality


--


Regards,


Peo Sjoblom

 

[Dick B]

Thank you very much for the help. It works great!!!!

Dick B