cell color

D

David NL

Hello best excellers.
I have a sheet for my empolyees with the days on which they should work.
I want to change the color of the cell automatically to blue whenever I put
a " v " (vacation) in it and it should work voor all the cells.

Sorry for my bad English if it is not understandabl.

Thanks in advance

David
 
R

Ray A

One way:
Highlight the range containing the data. With cell A1 active
Format>Conditional Formating>Change cell value is to formula is >enter
=a1="v" >click the format.... button and select the color blue.
HTH
 
Top