Conditional Formating with if then statement

0
votes

I have a workbook with 2 sheets, Sheet 1 has Column I. Column I is filled with Percent's. I want these %'s formatted as black or red based on conditional formatting.

Sheet 2 has cell B2 filled in with one of the following "Jan, Feb, Mar, Apr, May, 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 If the % in 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

1
excelformattingconditional

1 Answers

1
votes

The conditional formulas essentially already follows the IF logic, they are expecting a TRUE / FALSE response:

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

The conditional formatting will automatically increment the cell references based on the absolute referencing

The IF Statement is null and void but if it helps you to understand, you would use it like so:

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

This will then return the TRUE / FALSE that the conditional formatting is expecting