I made a spreadsheet for scheduling employees. I often grant leave (vacation, sick, etc...etc...), and fill the open positions. I have about 7 different variables. Conditional formatting works great, but for only 3 of the 7 variables.
I'm looking to fill the cell color and change the font color when I enter
certain text into the cell, including empty cells.
for instance...if a cell is empty - color =red
cell has "AL" - color=blue, text=white.
and so on....and so on - 7 different variables.
I don't need every cell in the worksheet to do this, I need this to work in 4 different cell ranges.
Is this possible?
JF
Bookmarks