Thread: cell color
View Single Post
  #3   Report Post  
Ray A
 
Posts: n/a
Default

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