C clumpa Member Oct 8, 2010 #1 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
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 Oct 9, 2010 #2 Clumpa try the following conditional formatting formula =IF(MIN($B$4:$J$4,$L$4:$T$4)<3,TRUE,FALSE) Adjust ranges to suit
Clumpa try the following conditional formatting formula =IF(MIN($B$4:$J$4,$L$4:$T$4)<3,TRUE,FALSE) Adjust ranges to suit