Ok, i'll do my best to explain this - i'm working on a sensitive document, so i can only post a blank example.
Example.xlsx
I'm trying to make the full document easier for people to see where inputs are required. What i'm looking for here is a formula i can use within the conditional formatting to highlight row 47.
I would like row 47 to highlight if the following are true;
A47 is blank
A46 > 0
S53 > 0 or S54 > 0
N46:N49 does not contain "OS"
Bookmarks