Excel query

aliasojo

OH has had his shift pattern for the next year emailed to him as an Excel worksheet. His days off have been highlighted in blue and tbh it's a bit distracting.

Since his days off every week are different, the blue shaded cells are erratically spaced. Is there a way of changing all of these at once or do I have to physically go through the sheet highlighting each cell before manually changing colour?

scottishf

You could just choose a cell which has no shading..select the cell.....hit the format painter...then use it to paint the format to all the offending shaded cells.

davb

You can drag a window around them, select an entire row or column, select everything by clicking top left, or multiple select by holding down CTRL - depends if you have other cells you don't want to change colour.

aliasojo

Thanks but I dont think either of those options are what I need.

The other cells on the sheet are white with black font. They need to stay the same.

The blue coloured cells, I want to change to a pale grey.

I can't change entire rows or columns because the cells are intertwined iyswim?

scottishf

depending what is in the cells, you could possibly use conditional formatting

davb

If there are too many cells to use CTRL +multiple select, then you may be able to use a macro that uses the current colour as a trigger to change with. It's not something I have ever done, but there a few Google possiblities.

aliasojo

davb wrote: »

If there are too many cells to use CTRL +multiple select, then you may be able to use a macro that uses the current colour as a trigger to change with. It's not something I have ever done, but there a few Google possiblities.

I think this is what I need but it sounds too complicated tbh. I know the basics with Excel but nothing too involved. I guess I'll just have to spend some time with the CTRL and select option.

Thanks.

scottishf

did you look into the conditional formatting ?

aliasojo

scottishf wrote: »

depending what is in the cells, you could possibly use conditional formatting

The blue cells are just blue shading, no other info or formatting.

I have no idea what conditional formatting is although I did see the option. I didn't know what to do with it do I closed the option box down again.

I wonder if there are any night classes that deal with Excel for numpties, I think it would be useful for me.