Conditionnal formatting based on 3 cells

[1995maaike]

Hi all,

I want to make D11 red, but only if C10:C12 are all filled. So if 2 out of 3 cells are filled, I want it to remain white. Anyone any idea how to do this?

Thanks in advance!

[#2]

@1995maaike 

You may use conditional formatting rule with formula

=AND( $C$10:$C$12<>"" )

[#3]

Hi Sergei,

Thanks for your reply. Unfortunately when using this formula cell D11 colors red if only 2 out of 3 cells are filled.

[#4]

@1995maaike 

Strange.

[#5]

@Sergei Baklan 

I'm working in google sheets, maybe that's the problem. Unfortunately I don't have acces to Microsoft 365

[#6]

@1995maaike 

It shall work in Google Sheets as well. Where are C10:C12 on your screenshot and where is D11 to which the rule is applied?

[#7]

@Sergei Baklan 

Hopefully this makes it more clear

[#8 · Accepted solution]

@1995maaike 

Strange, but in Google Sheets

and in Excel

formula works differently.

Anyway, you may use

=($C$10<>"" )*($C$11<>"" )*($C$12<>"" )

it shall work in both.

[#9]

It works, thank you very much for your help and time!

[#10]

@1995maaike , you are welcome