I'm looking to use conditional formatting in Google sheets for a work project. I want to get 3 different formats. Basically if columns F & H were blank were would highlight them red. If cell F was filled in but cell H was blank then we would highlight the cells yellow and if both cells F & H were filled in then we would highlight it green.

How can I do this in google sheets, with a nested if statement? I'm having trouble putting together the right formula

enter image description here

CodePudding user response：

Try this: Go to Conditional Formatting; Select the range to which this will apply; Then choose in Format cells if... Custom Formula;

Conditional Formatting 1:

=AND($F2="";$H2="")

Conditional Formatting 2:

=AND($F2<>"";$H2="")

Then you get the idea.