Forum Discussion
Conditional formatting - new rule based on two related column headings
Need to create a new rule that changes cell colors (column H) based on more than 2 falls (column C) in 30 days for the same person (column A). I've found the formula for just the date - but not for a...
Added two conditional formatting for column H. Green supersedes yellow, i.e. if the conditions for both yellow and green are met, green takes precedence. Example with John Wick:
First fall is green because the condition for green is met although he fell twice within 30 days which should give him yellow.
Second fall is yellow because only the condition for yellow is met.
Thank you - this is very helpful. So the formula is: =OR(ISERROR(SEARCH("sutures",G1))=FALSE,ISERROR(SEARCH("steristrips",G1))=FALSE,ISERROR(SEARCH("splint",G1))=FALSE,ISERROR(SEARCH("sprain",G1))=FALSE)