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

TheBigMac 1 Posts Friday March 31, 2017Registration date March 31, 2017 Last seen - Mar 31, 2017 at 12:51 PM - Latest reply: Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen
- 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.
See more 

3 replies

Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Mar 31, 2017 at 02:55 PM
0
Thank you
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
Good morning.
Yes, you were correct, I meant to say Columns, not rows.
This did work. Thank you very much.
Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Apr 3, 2017 at 10:31 AM
0
Thank you
TheBigMac, Good morning.

Thanks for the feedback.

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