| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font to change color automatically based on value in cell.
I have a cell that includes a formula for a particular take rate, if that
take rate is over or below the targeted take rate, I would like the font to change color. I'm thinking it is an if statement, for example if goal is 20% and value is 21% change font to bold blue. I am using Excel 2003. Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Font to change color automatically based on value in cell.
You need to use Conditional Formatting
Regards Trevor "mtwelsh72" wrote in message ... I have a cell that includes a formula for a particular take rate, if that take rate is over or below the targeted take rate, I would like the font to change color. I'm thinking it is an if statement, for example if goal is 20% and value is 21% change font to bold blue. I am using Excel 2003. Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Font to change color automatically based on value in cell.
Use conditional formatting, with a value greater than 20% or a custom format
of [Blue][0.2]0%;[Black][<=0.2]0%;General -- HTH RP (remove nothere from the email address if mailing direct) "mtwelsh72" wrote in message ... I have a cell that includes a formula for a particular take rate, if that take rate is over or below the targeted take rate, I would like the font to change color. I'm thinking it is an if statement, for example if goal is 20% and value is 21% change font to bold blue. I am using Excel 2003. Thanks! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Font to change color automatically based on value in cell.
Look at Format=Conditional Formulas
-- Regards, Tom Ogilvy "mtwelsh72" wrote in message ... I have a cell that includes a formula for a particular take rate, if that take rate is over or below the targeted take rate, I would like the font to change color. I'm thinking it is an if statement, for example if goal is 20% and value is 21% change font to bold blue. I am using Excel 2003. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change font color automatically | Excel Discussion (Misc queries) | |||
| how do i change row font color based on cell value in that row | Excel Worksheet Functions | |||
| change font color of cell based on critera | Excel Worksheet Functions | |||
| How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
| How can I automatically change the font color of text in cells th. | Excel Discussion (Misc queries) | |||
Hybrid Mode
