Oct 01 2021 07:05 AM
I am looking to write a conditional formatting formula -
What I am looking for is if Cells K2 & L2 are 'Y' fill cell k2 green?
Any thoughts if this can be done - I have tried =if and =ifs I just might be writing it wrong.
Oct 01 2021 07:28 AM - edited Oct 01 2021 07:28 AM
Oct 01 2021 08:03 AM
Oct 01 2021 08:09 AM
@tj2ceo Use double quote marks around the Y but no qoute marks around the formula itself.
=AND($K$2="Y",$L$2="Y")