cell function
If you click format, select conditional formatting and do as I described you
will get this functionality
--
Regards,
Peo Sjoblom
"Dick B" wrote in message
...
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" wrote:
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
|