CODEWITHSUNDEEP
google-sheetsgs-conditional-formatting
Remco Edelenbos
Remco Edelenbos

Reputation: 29

Google Sheet conditional formatting

I'm trying to get a format: I want the cel in column A be orange when the date is past and the task is nog checkt done. This is working, but he formats my hole range. A second formatting with a Cel is blank doesn't work. If there is no task i don't want it to be orange..

Screenshot

Upvotes: 0

Views: 45

Answers (1)

ziganotschka
ziganotschka

Reputation: 26836

The problem comes from the $ in your formula

It formats all cells based on row 4.

Additionally, if you want to implement the condition that the date should not be blank, you need to add into your AND statement ISBLANK(D4)=FALSE

Change your formula to

=AND(D4<TODAY(),E4=FALSE,ISBLANK(D4)=FALSE)

Upvotes: 0

Related Questions