selfteaching
03-04-2019, 02:01 PM
Hi
I’m trying to have conditional format change the format of a cell to red if a condition is true based on a different cell and then copy it down about 30 cells with the based cell moving with it
For ease of explaining:
When I enter a number in E4, I want it to look at I3.
If it’s not the same, change the font in E4 to red, so I will notice it.
Then later when I enter a number in E5, I want it to look at I4, with the same condition.
Then E6 compares with I5, etc
When copy it down, it still looks at I3
I tried to paste>>special>>all merging conditional format
I also tried to use the format painter from the ribbon
The conditional format formula adds the &’s ($I$3)
When I change it to I3, it doesn’t work
I can't make it work because the compare cell will change
I don't really want to make a different conditional format rule in each E cell 30 times :(
mike
I’m trying to have conditional format change the format of a cell to red if a condition is true based on a different cell and then copy it down about 30 cells with the based cell moving with it
For ease of explaining:
When I enter a number in E4, I want it to look at I3.
If it’s not the same, change the font in E4 to red, so I will notice it.
Then later when I enter a number in E5, I want it to look at I4, with the same condition.
Then E6 compares with I5, etc
When copy it down, it still looks at I3
I tried to paste>>special>>all merging conditional format
I also tried to use the format painter from the ribbon
The conditional format formula adds the &’s ($I$3)
When I change it to I3, it doesn’t work
I can't make it work because the compare cell will change
I don't really want to make a different conditional format rule in each E cell 30 times :(
mike