• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Condition Format when a specific value in a range of cells

clumpa

Member
I have a spreadsheet holding name then 2 ranges of scores (holes 1-9 & 10-18). If the player has scored a 2 in either range I want to highlight their name
 

Hui

Excel Ninja
Staff member
Clumpa

try the following conditional formatting formula

=IF(MIN($B$4:$J$4,$L$4:$T$4)<3,TRUE,FALSE)

Adjust ranges to suit
 
Top