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

         

         

         

Resources