cell function
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 |
cell function
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 |
cell function
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 |
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 |
cell function
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 |
All times are GMT +1. The time now is 07:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com