Conditional Format question

[Scooter172]

I have a schedule in Xcel that I want a row say 1-17 colums c-h and its contence to change colors based on if the information in Column B1:B17 matches the information in Cells B23:B25.

This would blank out the schedule of hours and days in all columns in that row of Person a in row who is indicated on Vacation in Cells in B23:B25

B1 = B23 so therefore row 1 C1 - H1 turn a color

I want to use conditional formatting but can this be done without a Macro, would this be better served using a cond format based on formula?
I have already named tha ranges of B1:B17 as Scheduledetail and B23:B25 as OnVacation

[Bob Phillips]

Select C1:H17 and than a conditional format formula of

=ISNUMBER(MATCH(B1,$B$23:$B$25,0))

and set the fill colour.

[Scooter172]

This makes The first Cell in the row turn color but those that follow do not... Checked if Conditional formula is correct and it is?

[Bob Phillips]

Should do, because you are not running ISNUMBER against the text, but against the result of matching that text value against a range.

[Scooter172]

Only The first Cell in the row changes, not the entire row. Seems to be the only flaw.

[Bob Phillips]

My formula was slightly flawed, it should have been

=ISNUMBER(MATCH($B1,$B$23:$B$25,0))

[Scooter172]

That worked,,, Thanks!

[Scooter172]

After installing this formula it works fine as long as (the cells being referenced for the match "cell" is driven by a VLookup formula. I have noticed that this causes the Conditional Formula to Fail completely.

[Bob Phillips]

Not sure what you men. Post the workbook and point out an example.

[Scooter172]

I do not see any link or button to attach a workbook

[Bob Phillips]

Click the Advanced button on the post and then Manage Attachments.