Highlight column conditional formatting

[chrissmarlow]

Hi,

I have been using the formula =INDIRECT("A"&ROW())="sun" in conditional formatting for a while now and have had no issues with it. If the word "sun" appears in column A, the whole of that row will be formatted as requested. Great! But now im trying to switch it around to work with columns and im struggling!

I want a formula that will highlight cells below if the top one's value is "Sun". Is there any easy way to do this?

My current spreadsheet is:

Cell B13 is the header which may or may not contain the word "sun", if it does contain "sun" then I want cells B14:B26 to highlight in grey.

Any help much appreciated!

 

[Lewiy]

Try:

=B$13="sun"

Not sure why you are using indirect for the row, surely:

=$A1="sun" would suffice?

Hope that helps

 

[chrissmarlow]

Try:

=B$13="sun"

Not sure why you are using indirect for the row, surely:

=$A1="sun" would suffice?

Hope that helps

Haha, so simple! The reason I was using indirect is because someone gave me that formula ages ago and I just assumed it was needed, thanks for the correction!

One other thing, how easily could I make the formula work if cell B13 contained "Sat" OR "Sun" ?

Thanks again!

 

[Jonmo1]

One other thing, how easily could I make the formula work if cell B13 contained "Sat" OR "Sun" ?

Thanks again!

Try

=OR(B$13="Sat", B$13="Sun")

 

[chrissmarlow]

Try

=OR(B$13="Sat", B$13="Sun")

Thanks!