I need to have the least amount in a row of cells automatically highlight in a differant color.
O oceantravel Oct 3, 2005 #1 I need to have the least amount in a row of cells automatically highlight in a differant color.
J JE McGimpsey Oct 3, 2005 #2 One way: Select the row (say, row 1, with cell A1 the active cell). Choose Format/Conditional Formatting... CF1: Formula is =A1=MIN(1:1) Format1: <patterns>/<different color>
One way: Select the row (say, row 1, with cell A1 the active cell). Choose Format/Conditional Formatting... CF1: Formula is =A1=MIN(1:1) Format1: <patterns>/<different color>
