Hi All,
Trust we are having a great day.
Small problem i can not seem to get right. There is a bunch of data we have and if any of the cells are blank we need the cell in column E to turn Red
I have a spreadsheet with data beginning on i = 3
Data Range to look for blankcells is I to O
Conditions to search the range:
If cell in column P = "Active" then
If cell in column H <> "Summer" then
Any clues?
Bookmarks