Format Cell with Color

S

Stefan

I have sells that have value of either B or S

I would like all the B cells to appear Green and all the S cells to appear
Red.

How can this be accomplished.
 
F

FSt1

hi,
Conditional Formating might work. high light all the cell you wish to have
this formating then on the tool bar ... Format>conditional Formating.
Condition 1 - if cell Value - is equal to - ="B" - set format Patterns =
Green
Condition 2 - if cell Value - is equal to - ="S" - set format patterns =
Red

Regards
FSt1
 
Top