Cell Fill Colour

[bnwash]

Hi,

Need help to be able to fill a col with colour if the cells match.
I have attached an example

Assistance appreciated

[ragulduy]

Please Login or Register  to view this content.

[etaf]

NOTE merges cells do not mormally work very well with formulas - and so the merge cell is being seens AS D3
Select cells D8 to D16 then
Put this
=D8=DATE(YEAR($D$3),MONTH($D$3),DAY(D$6))
as a conditional format formula and enter

Now select D8:D16 and copy - select E8:Q16 and paste special > format

see attached spreadsheet update

[bnwash]

Thanks for that but I have tried the code in the test sheet and cannot seem to get it to work
are you are able to assist

[bnwash]

Perhaps I am not clear in what I am after
If the date in col D is in the area D8 to q16 then only that date is to be filled
e.g. 2/12/13 the col d5 to d 16 would be coloured blue
The other date in the list is 9/12/13 so again L5 to 16 would be blue
The Grey for the Sat and Sun to remain but as indicated only the dates nominated to be filled with a colour
Hop that clarifies

[ragulduy]

Thats what the code I posted did when I tried it on the example you posted. Not sure what is different for you but it is probably to do with the date formatting.

[bnwash]

So you were able to get the code to highlight only the col with corresponding dates in col w

[ragulduy]

Yes. It highlighted in the blue colour the dates you had listed.

[etaf]

So you were able to get the code to highlight only the col with corresponding dates in col w

no I was matching with
the month and year in D3 and the Days in row 6

So did not use column W and how big will column W get - probably better to stay with yudlugar VBA/Macro solutions

[bnwash]

I cannot get the code to work on my example - attention yudlugar

[ragulduy]

I've been back and double checked, I copied the code back into the example workbook and run it, I got cell L6 highlighted in blue.

As I said earlier, if this doesn't work the most obvious problem will be to do with date formatting on our machines. Maybe try running this macro and tell me what you get in cells A1 - A4

Please Login or Register  to view this content.

I'll then see if I can change my code to get it to work for you

[bnwash]

Sorry I could not get back to you earlier.
No I cannot get it to work using either code

[FDibbins]

Try this regular Conditional formatting approach...

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =ISNUMBER(VLOOKUP($D$3+D$6-1,$AL$6:$AL$11,1,0)) format fill the color you want

[bnwash]

Many thanks that worked just fine
Appreciate the help