Whole sheet conditional formatting

[berhurt]

I'm trying to get the conditional formatting so that if a certain cell in a row gives a certain text value, then the whole row will be shaded a certain way. I get how to do this for one row using: -

Formula Equals; =IF($A$1="text_value",TRUE(),FALSE())...

...then applied to all the cells in that row.

But I do not want to have to do this separately for each row. Is there a way I can achieve something like: -

Formula Equals; =IF([value of column in this row]="text_value",TRUE(...

...and then apply it to the whole sheet?


Any help much appreciated!

[Bryan Hessey]

I'm trying to get the conditional formatting so that if a certain cell in a row gives a certain text value, then the whole row will be shaded a certain way. I get how to do this for one row using: -

Formula Equals; =IF($A$1="text_value",TRUE(),FALSE())...

...then applied to all the cells in that row.

But I do not want to have to do this separately for each row. Is there a way I can achieve something like: -

Formula Equals; =IF([value of column in this row]="text_value",TRUE(...

...and then apply it to the whole sheet?


Any help much appreciated!

Hi,

to set a formula that applies to a range, select the range, and enter the formula that applies to the active cell, (the odd coloured one)

=If($A1="c",true,false)

etc, should work for you.

---

[berhurt]

Thanks for the response Byran,

But what you've given me only applies to the line which contains A1. I've tried using this form and applying the format to the rest of the sheet, but all I get is the entire sheet referring to A1 for conditional formatting. My problem is to get row 2 to check A2, row 3 to check A3...etc. without having to type the formula for each individual line.

Any ideas?

[Bryan Hessey]

Thanks for the response Byran,

But what you've given me only applies to the line which contains A1. I've tried using this form and applying the format to the rest of the sheet, but all I get is the entire sheet referring to A1 for conditional formatting. My problem is to get row 2 to check A2, row 3 to check A3...etc. without having to type the formula for each individual line.

Any ideas?

No

Did you try it?


as

to set a formula that applies to a range, select the range, and enter the formula that applies to the active cell, (the odd coloured one)

=If($A1="c",true,false)


added with the whole sheet selected, A1 as the active cell, the attached was formatted. Put a 1 in any row in A column to test.
---


If you still have a problem then paste your formula here. note Don't use $A$1
---

[berhurt]

Great thanks for your help

I didn't notice is was $A1 instead of $A$1.

Thanks again!

[Bryan Hessey]

Great thanks for your help

I didn't notice is was $A1 instead of $A$1.

Thanks again!

np - good to see it worked for you, and thanks for the response.

---