I am trying to maintain a spreadsheet of races and personal bests for runners. My runners are in rows. The races and Mile Split times are in columns. My data ranges from C3 through Y53. I have a separate column, using the MIN function, for their best Mile Split time YTD, Column Z.
I'd like to highlight whichever cell, in each row, matches the corresponding time in column Z. For one runner, it might be C3 that equals Z3. For another, maybe their G12 matches their Z12.
Any help is greatly appreciated.
Chg background color of any cell in range based on another cell
The way CF is applied has changed in the later versions of Excel when they started using ribbons.
Let's see if this works for you (ribbon method):
- Select all the cells you want to apply the CF to (i.e. C3:Y100).
- Find the CF button on the Start ribbon, click on new rule and choose to use a formula.
- Type in the following formula: =C3=$Z3 and choose your format.
- Confirm your actions and see if the right cell(s) changes format.