Related:
- Copying cond. format for entire row based on 1 cell to other row
- Conditional formating for entire rows ✓ - Forum - Excel
- Copy conditional formatting for an entire row based on one cell ✓ - Forum - Excel
- Copy entire row to another sheet based on cell value ✓ - Forum - Excel
- Move entire row to another sheet based on cell value ✓ - Forum - Excel
- Excel vba copy entire row with formatting - Forum - Excel
2 replies
Mazzaropi
- Posts
- 1868
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- January 15, 2021
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
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
Subscribe To Our Newsletter!
Yes, you were correct, I meant to say Columns, not rows.
This did work. Thank you very much.