cell function

  • Thread starter Thread starter Dick B
  • Start date Start date
D

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
 
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
 
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.
 
If you click format, select conditional formatting and do as I described you
will get this functionality


--


Regards,


Peo Sjoblom
 
Back
Top