Hi I attach some sample data. I want excel to see the conditionally formatted (cells in red) (G) then check in (B) if any of the corresponding duplicate rows show "HHI" then set (H) as "OK". Is this possible? Many thanks David