| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using the IF function to automatically change the color of the fon
Let say i want to set up a scenerio that says if A12 is less then 60% change
font to red. I am not sure how to go about doing this. I understand IF formulas but not advanced. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using the IF function to automatically change the color of the fon
hi
formula can't do this but conditional formating can. on the menu bar... formatconditional format.... cell value is less than .6 pick your format. regards FSt1 "Max1103" wrote: Let say i want to set up a scenerio that says if A12 is less then 60% change font to red. I am not sure how to go about doing this. I understand IF formulas but not advanced. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using the IF function to automatically change the color of the
Thank you so much. I really appreciate that
"FSt1" wrote: hi formula can't do this but conditional formating can. on the menu bar... formatconditional format.... cell value is less than .6 pick your format. regards FSt1 "Max1103" wrote: Let say i want to set up a scenerio that says if A12 is less then 60% change font to red. I am not sure how to go about doing this. I understand IF formulas but not advanced. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using the IF function to automatically change the color of the fon
Select Cell A12. From the xl menu choose Format - Conditional Format.
In the dialog that opens choose Cell value is less than 0.6 Change the format to a red font. -- HTH... Jim Thomlinson "Max1103" wrote: Let say i want to set up a scenerio that says if A12 is less then 60% change font to red. I am not sure how to go about doing this. I understand IF formulas but not advanced. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data change color automatically | Excel Worksheet Functions | |||
| Why does my color palette automatically change? | Excel Worksheet Functions | |||
| Change text color in a cell automatically | Excel Discussion (Misc queries) | |||
| How do I automatically change color of value if value is > 50 in . | Excel Discussion (Misc queries) | |||
| How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
Hybrid Mode
