conditional format formula help based on match of data in another worksheet

It is easier in this case to set up the conditions for one row, and then you can easily change the range it applies to. So, select the cells A2:E2 then click on Conditional Formatting | New Rule | Use a formula... , then put this formula in the dialogue box which pops up:

=$A2='Docket Sheets'!$I$1

Note that there is no $ symbol in front of the 2 of A2.

Click on the Format button | Fill tab and choose your colour, then OK twice to exit the dialogue box.

Then click on Conditional Formatting | Manage Rules then adjust the Applies to box to cover the range you really want.

Note that in some earlier versions of Excel you could not refer to other sheets directly in a CF condition, but the way round that would be to use a named range. If this is the case with your version, apply a named range to the cells I1:J1 in the Docket Sheets sheet, and use that name in the CF condition.

Hope this helps.

Pete

Really appreciate it Pete_UK! Thanks so much!

You're welcome, and thanks for the rep.

Pete