To help identify issues faster I am trying to add conditional formatting for column Z to turn red if the amount in that column is greater than the amount in the columns AA or AB and only if column AA or AB is not 0.
I tried the following after putting “Z2:Z” for the Apply to range and “Custom formula is” for the Format rules:
Also, I am starting from row 2 as row 1 contains the headers.
But I can not figure out how to specify the not 0 part for both column AA and AB.
This feels like it should be a pretty basic formula but I am bit rusty on my functions/statements.