Font color
 

Can I change font color based on equations < or

I would like an equation that says if the number in C1 is B1 then font
color is blue and if C1 is < B1 then font color is red.

Is there such a function?

Font color
 

You need to look at conditional formatting.
--
David Biddulph

"cyrock1" wrote in message
...
Can I change font color based on equations < or

I would like an equation that says if the number in C1 is B1 then font
color is blue and if C1 is < B1 then font color is red.

Is there such a function?

Font color
 

hi
no, there is not such a function but you can use conditional fomating.
not sure where you want the conditional formating, in b1, c1, both or
somewhere else. lets say C1. selecft C1
on the menu bar...
formatconditional formating.
in the left drop down select cell value is.....
in the next box, select greater than....
inthe last box, enter B1.
click the format button, select font, color = blue
Click the add button.
for the second conditon.
in the left drop down select cell value is.....
in the next box, select less than....
inthe last box, enter B1.
click the format button, select font, color = blue
click ok.
post back if you have problems.

Regards
FSt1

"cyrock1" wrote:

Can I change font color based on equations < or

I would like an equation that says if the number in C1 is B1 then font
color is blue and if C1 is < B1 then font color is red.

Is there such a function?