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.
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.
1995maaike , you are welcome
- It works, thank you very much for your help and time!