Hi, your formula is correct but your approach is probably wrong. Start by selecting cell A12 then make the rule in the CF, make sure you have the correct relative referencing, and apply on A12 only. Confirm, then change the apply on to the full range.
Attachments
Copy of Highlight entire row based on Cond Formt-1.xlsx