Looked up a few guides, but nothings working. I want to conditional format a table that checks a date (G2) that's less then TODAY() AND if H2 or I2 are False, then highlight the entire row. The formula I've tried using was: =AND($G2<TODAY()-60,$H2="FALSE",$I2="FALSE"). I want to highlight the whole row if G2 is older than 60 days. If the date is current, then if "H" & "I" say FALSE, then it will highlight the whole row. If both are current and TRUE, nothing is highlighted. I'm thinking an IF statement in conjunction with an AND may be necessary, I'm having issues figuring it out.
Attached is one line from a table. Table is A1:I41.
Attached is one line from a table. Table is A1:I41.