Previous Topic Next Topic

Copying cond. format for entire row based on 1 cell to other row

Solved/Closed
TheBigMac
Posts
1
Registration date
Friday March 31, 2017
Status
Member
Last seen
March 31, 2017
 - Mar 31, 2017 at 12:51 PM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 - Apr 3, 2017 at 10:31 AM
I have conditional formatting for an entire row based on the value of 1 cell. For example: cell value>$A$2 = red, cell value<$A$2 = green. This format is applied for the entire row.
I want to copy this formatting to the next 150 rows where the formatting in each row is based on cell 2 in each row.
When I copy them over, they revert back to be based on cell A2 for every row.

I hope this makes sense.

2 replies

Answer 1 / 2
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 147
Mar 31, 2017 at 02:55 PM
TheBigMac, Good afternoon.

Are you talking about rows or columns?

It looks like you want Column A to have rules based on cell at row 2.

And you then want to copy this format to other columns, type: B, C, D, up to ET.

Just remove the $ sign from the column in the formula.

Before: cell value>$A$2 = red
Now...: cell value>A$2 = red

Please, tell us if it worked as you desire.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
TheBigMac
Apr 3, 2017 at 09:09 AM
Good morning.
Yes, you were correct, I meant to say Columns, not rows.
This did work. Thank you very much.
0
Answer 2 / 2
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
 147
Apr 3, 2017 at 10:31 AM
TheBigMac, Good morning.

Thanks for the feedback.

Glad to help you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0