Conditional formatting if cell value is between certain values, but only if another cell contains specific text

[strongman86]

Hi Lads,

How do I set up conditional formatting to highlight cell C1 if it's values are between 10 and 15, but only if cell A1 contains text APPLE.

 

[philwojo]

Try this as a CF formula

=and(c1>=10,c1<=15,a1="apple")

 

[kweaver]

=and(a1="apple",c1>=10,c1<=15)

 

[tyija1995]

Hey,

Click cell C1 then go to Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=AND($A$1="Apple",$C$1>=10,$C$1<=15) --> Format with a fill of your choice -> OK -> OK

 

[strongman86]

Perfect. Thanks lads.