Shading cells based on Row 1 value

[gomesy]

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

[DonkeyOte]

Highlight A1:AZ62 (selecting A1 first) and apply a Conditional Format Formula based rule of:

=A$1="Approved"
set format accordingly

[gomesy]

Thanks but that highlights everything... I only want to highlight certain cells...

[DonkeyOte]

If you entered correctly (ie A$1="Approved" not $A$1="Approved") then you should find only columns A, C & D are formatted.

If in doubt please post a sample in which you've implemented the prior suggestion but have failed to obtain desired results.