Format Cell with Color
 

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.
--
Thanks in advance
Stefan

Format Cell with Color
 

hi,
Conditional Formating might work. high light all the cell you wish to have
this formating then on the tool bar ... Formatconditional 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

"Stefan" wrote:

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.
--
Thanks in advance
Stefan