SOLVED

# Conditionnal formatting based on 3 cells

Copper Contributor

# Conditionnal formatting based on 3 cells

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?

9 Replies

# Re: Conditionnal formatting based on 3 cells

You may use conditional formatting rule with formula

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

# Re: Conditionnal formatting based on 3 cells

Hi Sergei,

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

Strange.

# Re: Conditionnal formatting based on 3 cells

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

# Re: Conditionnal formatting based on 3 cells

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?

# Re: Conditionnal formatting based on 3 cells

Hopefully this makes it more clear

best response confirmed by 1995maaike (Copper Contributor)
Solution

# Re: Conditionnal formatting based on 3 cells

and in Excel

formula works differently.

Anyway, you may use

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

it shall work in both.

# Re: Conditionnal formatting based on 3 cells

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

# Re: Conditionnal formatting based on 3 cells

@1995maaike , you are welcome

1 best response

Accepted Solutions
best response confirmed by 1995maaike (Copper Contributor)
Solution

# Re: Conditionnal formatting based on 3 cells

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