Extra If then

Copper Contributor

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.

3 Replies

@tj2ceo The condition formatting rule could be:

 

=AND($K$2="Yes",$L$2="Yes") applied to $K$2

@Riny_van_Eekelen 

 

This is what I am attempting but it is not returning the correct format.  

tj2ceo_0-1633100394403.png

 

@tj2ceo Use double quote marks around the Y but no qoute marks around the formula itself.

 

=AND($K$2="Y",$L$2="Y")