Forum Discussion
Conditional Formatting with Exception
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 great...
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! 
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)