Changing text color based upon If

[KenM]

I have two colums with inventory numbers Column A is the three month
requirement, column B is quantity in stock. If B is less than A column, I
would like the text in B to change colors (to Red for instance). Any ideas?

Thanks,
KenM

 

[FSt1]

hi
conditional formating...
select b2, then on the tool bar
format>conditional formating.

formulal is.......=B2<A2......pick your color.

copy and paste formats down as far as you need.

regards
FSt1

Regards

 

[Gord Dibben]

Check out help for Conditional Formatting


Gord Dibben MS Excel MVP

 

[KenM]

Thank you. But is it possible to select cells B2 through B116 to have them
compare between A2 through A116 so that I wouldn't have to repeat the
function 115 times? I thought I might be able to select a group of cells to
apply the formula too. I am using 2007 by the way.

 

[FSt1]

hi
no i don't think conditional formatting works that way. each cell must be
set. but you can copy and paste special formats to set the column in mass
after setting one cell.
and i am stuck on 2003. in 2007,its the home tab>style group>conditioal
formating.

regards
FSt1

 

[David Biddulph]

You can certainly select a range of cells before you apply CF in Excel 2003.
I would be surprised if you can't in 2007, though I know that there have
been some "improvements".