Conditional Highlight a range of cells based on one cells value, with a relative reference
Good morning.
I would love some assistance with what i thought would be a fairly simple task, but alas, im not getting it
I have attached a sample sheet. What I am looking to do is conditionally format cells in columns B:E if the cell in column B contains the text "Shift".
I have tried the following as the formula in Conditional formatting, but with no luck :
I will have a number of Groups of columns across the page, the example only shows 2 sets.
The example sheet has some cells formatted manually to show how i want them to appear, but with conditional formatting as the data will change week to week, with the "Shift" headings being in different rows.
Re: Conditional Highlight a range of cells based on one cells value, with a relative refer
1. highlight the range you want to apply the conditional formatting to
2. on the home tabe, styles, select CF
3. select new rule, select use formula
4. enter =ISNUMBER(SEARCH("shift",$B2,1))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Bookmarks