I'm trying to do conditional formatting based on multiple conditions. I would like to have cell C4 turn green if any of these conditions are meet. D61=0 and D4>0 or E61=0 and E4>0….R61=0 and R4>0(for every column from D to R). If possible I would like for cell C4 turn red instead of green if more than one of these are true. I have tried a few different formulas and the closest I came would only turn C4 green if the D61=0 and D4>0 was true. Anything else didn't change the color. I know I could make multiple rules for cell C4 but would rater have 1 rule with a formula if possible.
Bookmarks