Conditional Formatting with Exception

[bsheppard]

Hey guys! I have read through many of the previous threads regarding conditional formatting exceptions, however, none of the formulas have been completely successful for me. Assistance would be greatly appreciated! 

I have a conditional formatting formula highlighting any row that contains 'YES' in column V, which works great... however, I need an exception to this rule. Basically, I need the formula to say "highlight any rows that contain 'YES' in column V, except when column L contains '058 - Miscellaneous Fees-Wtg to Bill"

I know how to unhighlight the specific cell, however, I need the entire row to be unhighlighted if this exception occurs not just the cell. THANK YOU!

Here is my current formula:

[#2]

Hi @bsheppard,

To create a conditional formatting exception in Excel, you can use the following steps:

1. Select the range of cells that you want to apply conditional formatting to.
2. Click on the Home tab and then click on Conditional Formatting.
3. Select New Rule from the drop-down menu.
4. In the Format values where this formula is true dialog box, enter the following formula:

=AND(V2="YES",L2<>"058 - Miscellaneous Fees-Wtg to Bill")​

This formula will highlight any row that contains "YES" in column V, except when column L contains "058 - Miscellaneous Fees-Wtg to Bill".

1. Click on the Format button and select the formatting that you want to apply to the cells.
2. Click on the OK button.

Once you have completed these steps, the selected range of cells will be conditionally formatted, with the exception of any rows that contain "058 - Miscellaneous Fees-Wtg to Bill" in column L.

The screenshot you provided shows the following conditional formatting formula:

=V2="YES"

This formula will highlight any cell that contains "YES" in column V. However, it does not include an exception for rows that contain "058 - Miscellaneous Fees-Wtg to Bill" in column L.

To create the conditional formatting exception, you can use the following formula:

=AND(V2="YES",L2<>"058 - Miscellaneous Fees-Wtg to Bill")

This formula will highlight any row that contains "YES" in column V, except when column L contains "058 - Miscellaneous Fees-Wtg to Bill".

Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.

If the post was useful in other ways, please consider giving it Like.

Kindest regards,

Leon Pavesic
(LinkedIn)

[#3]

@LeonPavesic Thank you! 

When I use the formula provided, only the cell is highlighted (red) as seen below:

The correct data is being highlighted just not the entire row as desired. 

Here is the formula as entered in Excel:

What should I adjust to make sure the entire row is highlighted (red)? Thanks for the help! 

[#4]

@bsheppard 

Change the formula in the rule to

=AND($V2="YES",$L2<>"058 - Miscellaneous Fees-Wtg to Bill")

(with a $ before the column letters to "fixate" them)