Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
cell color
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 |
#2
|
|||
|
|||
Select all the cells, then hit Format--Conditional formatting, David.
Choose Cell Value = and type a V into the box. ************ Anne Troy www.OfficeArticles.com "David NL" <David wrote in message ... 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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
How bring a color on cell from one sheet to another | Excel Discussion (Misc queries) | |||
Current Cell Color | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |