Forum Discussion
Solved
Urgent help needed - copying conditional formatting to new cells
I have added conditional formatting to cell C6, there are 2 rules for that cell. if cell C7 is equal to or greater than C6 show green if C7 is less than C6 show red. I need to copy that form...
You should be able to apply conditional formatting to a range.
This one works for me. Am on a Mac, so your screen may look different but the settings will look similar on all platforms. The picture demonstrates how it works for a range C7:F7, but you can expand it to your liking. The yellow cell is in C6 and has no conditional format as it is your starting point.
Riny_van_Eekelen Thank you so much for your help, this has worked and saved me so much time!
You're welcome!