excel 2010 if=true change color

October 21, 2010 at 14:20:50
Specs: Windows Vista
I want to change font colour if a1<b1.
Have tried If(a1<b2,TRUE,FALSE) but it has not worked, I want this role also valid for a lot of ranges so I marked the area and also changed the font colour, then ok but all numbers was in black. What am I doing wrong?

See More: excel 2010 if=true change color

Report •


#1
October 21, 2010 at 14:52:33
re: I want to change font colour if a1<b1

Change font color of what?

re: If(a1<b2,TRUE,FALSE)

Why are you using B2?


Report •
Related Solutions


Ask Question