Macro/Conditional Formatting help

**denise6372** · 12-06-2009, 04:24 AM

Hi Everybody

I'm really struggling getting my head around a problem I have on an excel workbook. I need to be able to highlight many cells on many worksheets in black just the push of a button or similar! Any suggestions.

I seem to have gone around in circles and not achieved it and now have a fried brain.

Thanks heaps in advance

**royUK** · 12-06-2009, 05:03 AM

What criteria requires the highlighting?

Why not just use Conditional Formatting?

**denise6372** · 12-06-2009, 05:44 AM

Hey thanks for your response

Yes that's what i thought but i can't work out how to do it, which is really bizarre when you consider how much conditional formatting I've already used.

Basically I have tabs marked Jan - Dec and on each tab there are columns for each date in that month. This workbook is being distributed to different departments and some of them need Sundays blacked out and some don't, but I'd like them to be able to do it themselves from the welcome worksheet with the use of a "button", but I just can't work out how to do it.

Thanks
Denise

**royUK** · 12-06-2009, 06:06 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!