emfjsullivan
New Member
- Joined
- Apr 25, 2022
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
I am trying to copy Conditional Formatting rule from one cell to all the cells in the same column in Excel 2019
Here's my data:
A B
1 Col1 Col2
2 3 3
3 4 2
4 2 3
5 4 7
What I would like to do is have the fill turn red in Col2 when the value in Col2 > value in Col1. In the above, B4 and B5 should be red fill.
I was able to define conditional formatting for Col2 in the first row so that if Col2 becomes a 4, the fill becomes red (Col2 is actually a formula if that makes a difference).
What I would like to do is copy the conditional formatting rule of B2 to the other 3 rows (B3, B4, B5). I have a formula that works for B2 which is Cell Value > $A2. My understanding is if I have a $ in front of A, that value wont change but the 2 should become a 3/4/5 if I paste that formatting to the 3 other cells (B3, B4, B5). I've tried the following sequences with no luck, it always keeps $A2 and doesn't change to $A3, $A4, $A5 as expected.
I do a CTL-C to copy the B2 cell
I then drag my mouse to select B3..B5, then right click for Paste Special and have tried Keep Source Formatting and Merge Conditional Formatting but as I said, it always keeps the $A2 value as the comparison.
What am I don't wrong?
Here's my data:
A B
1 Col1 Col2
2 3 3
3 4 2
4 2 3
5 4 7
What I would like to do is have the fill turn red in Col2 when the value in Col2 > value in Col1. In the above, B4 and B5 should be red fill.
I was able to define conditional formatting for Col2 in the first row so that if Col2 becomes a 4, the fill becomes red (Col2 is actually a formula if that makes a difference).
What I would like to do is copy the conditional formatting rule of B2 to the other 3 rows (B3, B4, B5). I have a formula that works for B2 which is Cell Value > $A2. My understanding is if I have a $ in front of A, that value wont change but the 2 should become a 3/4/5 if I paste that formatting to the 3 other cells (B3, B4, B5). I've tried the following sequences with no luck, it always keeps $A2 and doesn't change to $A3, $A4, $A5 as expected.
I do a CTL-C to copy the B2 cell
I then drag my mouse to select B3..B5, then right click for Paste Special and have tried Keep Source Formatting and Merge Conditional Formatting but as I said, it always keeps the $A2 value as the comparison.
What am I don't wrong?