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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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.
Related:

2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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
Good morning.
Yes, you were correct, I meant to say Columns, not rows.
This did work. Thank you very much.
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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