Forum Discussion

1995maaike's avatar
1995maaike
Copper Contributor
Jul 03, 2023
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!
excel
Excel for web
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 03, 2023

    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.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 03, 2023

1995maaike 

You may use conditional formatting rule with formula

=AND( $C$10:$C$12<>"" )
1995maaike's avatar
1995maaike
Copper Contributor
Jul 03, 2023
Hi Sergei,

Thanks for your reply. Unfortunately when using this formula cell D11 colors red if only 2 out of 3 cells are filled.
    • 1995maaike's avatar
      1995maaike
      Copper Contributor
      Jul 03, 2023

      SergeiBaklan 

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

       

       

       

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jul 03, 2023

        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?

Resources