Report

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

Ask a question TheBigMac 1Posts Friday March 31, 2017Registration date March 31, 2017 Last seen - Last answered on Apr 3, 2017 at 10:31 AM by Mazzaropi
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 
Helpful
+0
plus moins
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
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.
Reply
Leave a comment
Helpful
+0
plus moins
TheBigMac, Good morning.

Thanks for the feedback.

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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!