Extra If then

%3CLINGO-SUB%20id%3D%22lingo-sub-2802815%22%20slang%3D%22en-US%22%3EExtra%20If%20then%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2802815%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20to%20write%20a%20conditional%20formatting%20formula%20-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20am%20looking%20for%20is%20if%20Cells%20K2%20%26amp%3B%20L2%20are%20'Y'%20fill%20cell%20k2%20green%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%20if%20this%20can%20be%20done%20-%20I%20have%20tried%20%3Dif%20and%20%3Difs%20I%20just%20might%20be%20writing%20it%20wrong.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2802815%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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")