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

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

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

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

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

Dick B

"Peo Sjoblom" wrote:

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