Font to change color automatically based on value in cell.

G

Guest

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!
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the font color based on the value of the cell 9
Change the font color based on value of cell 1
making a cell a certain font color based on condition 1
Change cell font color when cell is clicked 9
Changing font color based on type cell it is. How to do it? 6
Search and change font color to Red and bold it 1
Color rows based on a cell value 2
Lookup and Enter Value to Other Tab on Change in Cell 0

Top