Hi


My spreadsheet contains data from Column A to AZ and down to row 62 and I am looking to find a way to shade cells based on the top cell value.

I need to do this for every column in the range.


A B C D E
1 Approved Not Approved Approved Approved Not Approved
2 Dont Shade Dont Shade Dont Shade Dont Shade Dont Shade
3 Dont Shade Dont Shade Dont Shade Dont Shade Dont Shade
4 Shade Dont Shade Shade Shade Dont Shade
5 Shade Dont Shade Shade Shade Dont Shade
6 Shade Dont Shade Shade Shade Dont Shade
7 Dont Shade Dont Shade Dont Shade Dont Shade Dont Shade


Basically everytime the cell in row 1 contains Approved then the cells below are shaded.

Can anyone assist with this please?

Thanks

Iain