One way:
Highlight the range containing the data. With cell A1 active
FormatConditional FormatingChange cell value is to formula is enter
=a1="v" click the format.... button and select the color blue.
HTH
"David NL" wrote:
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
|