Conditional Formatting

[The_Game]

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.

 

[Fluff]

How about
=AND($G2<TODAY()-60,OR($H2="FALSE",$I2="FALSE"))

You may need to remove the " from the word FALSE.

 

[Joe4]

Are the values in columns H and I boolean or text?
If Boolean, then remove the double-quotes from around the World FALSE.

Also, the way you have written your formula, it is looking for BOTH H2 and I2 to be FALSE. If only one has to be, then it should be:
=AND($G2<(TODAY()-60),OR($H2=FALSE,$I2=FALSE))

 

[The_Game]

Columns H and I are text. Thanks guys for the quick replies!

 

[Fluff]

Glad we could help & thanks for the feedback.