Conditional Formatting

[MatthewLane412]

Hello, I have a workbook with 2 sheets, sheet one has column I. Column I is filled with Percent's.

Sheet has cell B2 filled in with one of the following "Jan, Feb, March, Apr, Jun, Jul, Aug, Sep, Oct, Nov, Dec."

The Conditional formatting formula I thought would be something along with lines of:

-------------If(Sheet2 cell B2 = "Feb" then I the % sheet 1 column I11-I31 the column is less than 10 divided by 12, color red.

then the same formula for each month but 9/12 for march and so on.

hopefully this makes sense. I appreciate everyone taking a look.

Thank you,
Matt

 

[6StringJazzer]

The fact you are using strings instead of real dates complicates things. Here is what I would use as the CF rule

=I11<MATCH(Sheet2!B2,{"Jan","Feb","March","Apr","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0)/12

Note that you said March instead of Mar. Double check that one.

 

[MatthewLane412]

That was a typo. it should have been Mar. I Use Hyperion at work so all our months are abbreviated.

the code I have come up with, with some help, isn't doing the trick. the code takes and I set the conditional formatting to turn all true results red, but everything stays black.

AND(Sheet2!$B$2="Feb,$I11<(10/12))

Thanks, Matt

 

[6StringJazzer]

That's funny, my formula did not stick in the post.

Should be

=I11<(12-MATCH(Sheet2!$B$2,{"Jan", "Feb", "Mar", "Apr", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"},0))/12