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) |