conditional formatting - if and statement

0
votes

I am working on an if/and statement in conditional formatting.

I have 2 sheets. --- YTD Summary and Parameters

I want to conditional format the following 'YTD Summary'! I11:I31 These are set up as Percentages. The Parameters page has cell B2 with one of the following variables depending on what month it is (Jan, Feb, Mar, Apr, etc.)

the formulas I have tried are as follows

AND(Parameters!$B$2="Oct,'YTD Summary'!$I$11<(3/12-.05))

and(Parameters!B2="Oct",'YTD Summary'!I11<3/12-.05)

Conditional formatting takes the formula, but doesn't turn any of the percentages red within the specified range (I11:I31). Yes, I have formatted it for red text. Any help would be much appreciated. I have spent way to much time on this. thank you, Matt

1
excelformattingconditional

1 Answers

1
votes
=AND(Parameters!B$2="Oct",I11<0.2)

enter image description here

This worked for me. If the B$2 reference needs to move downward with the values in I, then remove the $ before 2.

Thanks!