Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Copying cond. format for entire row based on 1 cell to other row [Solved/Closed]

Report
Posts
1
Registration date
Friday March 31, 2017
Status
Member
Last seen
March 31, 2017
 -
Posts
1838
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 26, 2020
 -
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.
See more

2 replies

Answer 1 / 2
Posts
1838
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 26, 2020
 136
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
Report

Good morning.
Yes, you were correct, I meant to say Columns, not rows.
This did work. Thank you very much.
Answer 2 / 2
Posts
1838
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 26, 2020
 136
TheBigMac, Good morning.

Thanks for the feedback.

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