L
Legacy 143009
Guest
I am quite weak at conditional formatting.
What should I do to paint column B cell values in red if column A value equals to matches any value in column C and the adjacent D value is smaller than column C value?
What should I do to paint column B cell values in red if column A value equals to matches any value in column C and the adjacent D value is smaller than column C value?
Column A | Column B | Column C | Column D |
Cat | 25 | Cat | 23 |
Bird | 4 | Dog | 10 |
Bird | 5 |