help! conditional formatting to highlight match for whole page

Hello

Highlight range B4:P100 and in CF rules, use this.

Formula:

=COUNTIF(sequence,B4)

I ssume that sequence is the named range of B2:P2


How can you use Conditional Formating.

--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.