Cond Format: Cell and Font color When Date<Today and another cell is <>100% for Google sheets

[davebar000]

Hey Gang,
Tried for quite a while and can't seem to hit the right syntax for accomplishing a conditional format of a cell (that I'll end up copying to all the cells in a column)

To illustrate:
Cell G9 holds a Date (it's a Due date for context)
Cell I9 holds a Percentage (it's a % complete for context)

What I'd like to do is change the formatting of G9's Background and text color when
G9 is earlier than today's date AND the value in I9 is NOT 100%
I'm using Google Sheets for this item

I just can't see to nail the right recipe in Google Sheets to make it work.
Very grateful for any assistance.

Thanks so much
-Dave

 

[Fluff]

Hi & welcome to MrExcel.
Not sure about goggle, but this is how it's done in Excel.
=AND(G9<TODAY(),I9<>1)

 

[davebar000]

That worked perfectly.... thanks so much!

 

[Fluff]

You're welcome & thanks for the feedback.