I can't figure this out, I know how to use conditional formatting to highlight a row, but some of these overlap:
Column D is between 0 and 30, turn green
Column D is between 31 and 45, turn yellow
Column D is greater than 45, turn red
The issue I'm running into is, Column D will always be greater than 0, so they all turn green no matter what. Any suggestions?
Column D is between 0 and 30, turn green
Column D is between 31 and 45, turn yellow
Column D is greater than 45, turn red
The issue I'm running into is, Column D will always be greater than 0, so they all turn green no matter what. Any suggestions?