Forum Discussion
d32bus
Jan 22, 2019Copper Contributor
Copy conditional formatting
Hi
I have a conditional formatting rule which basically says that if cell F24's value is less than cell F23s then turn the text red. But I'm struggling in copying and pasting this conditional formatting across an entire row as no matter which cell its copied into it takes the value for the source. eg. In the attached picture i've tried to copy it into the next cell, which is F24 but it still takes E23's value. I tried removing the dollar signs but this didn't seem to work. It's going to take a long time to set up conditional formatting on each individual cell. Many thanks in advance.
You may use formula like this applied to you range
2 Replies
Sort By
You may use formula like this applied to you range
- d32busCopper ContributorGreat, thanks for your help Sergei. Rob