If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
change text color when the value become lower than a certain value
Is it possible to set the text color which can be changed automatically. Say,
if 50 is the middle number, the number in the cell higher than 50, the text color become no change, otherwise, the text color will be changed for my preference. |
#2
|
|||
|
|||
change text color when the value become lower than a certain value
1. Select the cell. say A1
2. From menu FormatConditional Formatting 3. For Condition1Select 'Cell Value Is' and select 'Less than' and enter the value directly or refeerence another cell with that value (50) 4. Click Format ButtonFont and select your color (say Red) 5. Hit OK PS: If you are using XL2007 Goto Home tabStylesConditional Formatting -- Jacob (MVP - Excel) "change text color automatically" wrote: Is it possible to set the text color which can be changed automatically. Say, if 50 is the middle number, the number in the cell higher than 50, the text color become no change, otherwise, the text color will be changed for my preference. |
Thread Tools | |
Display Modes | |
|
|