Forum Discussion
Urgent help needed - copying conditional formatting to new cells
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.
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!
