FIll Cell If another cell is not null and another cell is TRUE

[lpaulg3]

How do write this?

If C6 is not null and B6 is TRUE (it's a check box), then fill A6 with a yellow color.
But, if C6 is null, then do nothing.

 

[mole999]

in CF something like

=AND(C6<>"",B6="True") then apply your format

probably need to fiddle with it and maybe test both halves separately before combining

 

[lpaulg3]

My Excel skills are very limited. I need it spelled out better than that - sorry.
Thanks for trying, though . . .

 

[mole999]

https://support.office.com/en-au/ar...rmatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f