How to do independent cell conditional formatting in the same row

Hannah Mills

I have the conditional formatting set up exactly as I need however, if the first rule is met, it then applies to the other "Days Outstanding" no matter if they are met or not.

For example, the IT status is "submitted" and days outstanding is greater than 3, so it is correct to be highlighted. However, the Security is "Approved" so therefore it should not be highlighted. When I change the IT status to "approved", the security status then is not highlighted.

I need these rules to be independent of their own column/cell.

Mark Cronk

Hi Hanna,

The piece of your conditional formatting you shared looks good. Do any of your other conditions reference Security Days Outstanding? Confirm that all are only applying formatting to the single cell you want highlighted. Confirm that the Security Days Outstanding cell isn't hard formatted Red. If all that looks good, the next level of troubleshooting is to start at the top and change the formatting on each criteria. Have it change green instead of red. Change it back if it doesn't cause the error. Figure out which criteria rule is causing the erroneous change. Fix it.

Good luck,

Mark