davebar000
New Member
- Joined
- May 18, 2020
- Messages
- 2
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
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