Forum Discussion
Solved
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?
Thanks in advance!
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.
- Hi Sergei,
Thanks for your reply. Unfortunately when using this formula cell D11 colors red if only 2 out of 3 cells are filled.
