Conditional Formatting Entire Row based off a cell value that contains IF function

In cell B2, I have a IF function that will either yield "Open" "Closed" "Over 45 Days" or stay blank based on two dates in cell A2 and M2.

I want to add conditional formatting so that whenever we enter in a new row of data, it'll automatically yield one of those options and the entire table row will be formatted either

yellow for open
green for closed
red for over 45 days

Original thread (for reference) here:
https://www.excelforum.com/excel-for...ml#post4767668

Since you want three colors, you will need to create three Conditional Formatting Rules.

Based on the table from your last post (A1:M5 with headers in row 1):

Rule 1: Highlight your entire table (A2:M5) > Conditional Formatting > New Rule > Use a formula
=$B2="Open"
Format: Fill yellow > OK > OK

Rule 2: Highlight your entire table (A2:M5) > Conditional Formatting > New Rule > Use a formula
=$B2="Closed"
Format: Fill green > OK > OK

Rule 3: Highlight your entire table (A2:M5) > Conditional Formatting > New Rule > Use a formula
=$B2="Over 45 Days"
Format: Fill red > OK > OK

See attachment to see the above steps in action.

Thanks, I'm not sure why it wasn't working for me. Maybe because I tried to select the entire sheet instead of just the table...

You're welcome. Yes, that would do it.

Conditional Formatting works based off of the top left cell in the selection.

Here's a simple example:
If you have data from C10 to E12 and you wanted to highlight every cell in that range with the letter "a" in it (only "a"), you would highlight C10:E12 and use the CF formula =C10="a".