Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if calculations
I am trying to figure out a way to make a cell change colors if a certain
condition is met. For example, if cell f4 is 192.27 or above, then the cell font should change to RED to show it is over the number it should be. If not, then it can stay whatever color it is. Can anyone figure out how to make this calculation?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if calculations
Hi
You need to use Format/Condional Formating. Select the cell and go to this option. From the dialog box set Cell Value Is along with =192.27. Then select a format and you're done! Andy. "TeddyBearDJ" wrote in message ... I am trying to figure out a way to make a cell change colors if a certain condition is met. For example, if cell f4 is 192.27 or above, then the cell font should change to RED to show it is over the number it should be. If not, then it can stay whatever color it is. Can anyone figure out how to make this calculation?? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if calculations
Hi!
Try this: Select cell F4 Goto FormatConditional Formatting Select Formula Is In the little box on the right enter this formula: =F4=192.27 Click the Format button Select the desired style(s) OK out Biff "TeddyBearDJ" wrote in message ... I am trying to figure out a way to make a cell change colors if a certain condition is met. For example, if cell f4 is 192.27 or above, then the cell font should change to RED to show it is over the number it should be. If not, then it can stay whatever color it is. Can anyone figure out how to make this calculation?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
complex calculations | Excel Discussion (Misc queries) | |||
Calculations based on PivotTable information | Excel Discussion (Misc queries) | |||
looping through a set of calculations | Excel Worksheet Functions | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
time interval calculations in excel | Excel Discussion (Misc queries) |