ollyhughes1982
Well-known Member
- Joined
- Nov 27, 2018
- Messages
- 677
- Office Version
- 365
- Platform
- MacOS
Hi,
I have been adding some conditional formatting to one of my worksheets. What I have works as it should, but i would like to simplify it, if this is possible. As I'm going through the sheet I am building a massive list of formats and wondered if there was a way that I could perhaps combine them where they are looking at the same dataset. In the example link I have given the example of my alphabet range, as per screenshots.
I was thinking, for example, for the line A-E, perhaps the 5 separate conditions could somehow be combined into one? Not sure if this is possible, but would definitely help if I could do this somehow.
Like i said, they work perfectly fine as is, it's more about efficiency and having to manage so many different conditions.
File is here: Analogue Scorecard.xlsx
Thanks in advance!
Olly.
I have been adding some conditional formatting to one of my worksheets. What I have works as it should, but i would like to simplify it, if this is possible. As I'm going through the sheet I am building a massive list of formats and wondered if there was a way that I could perhaps combine them where they are looking at the same dataset. In the example link I have given the example of my alphabet range, as per screenshots.
I was thinking, for example, for the line A-E, perhaps the 5 separate conditions could somehow be combined into one? Not sure if this is possible, but would definitely help if I could do this somehow.
Like i said, they work perfectly fine as is, it's more about efficiency and having to manage so many different conditions.
File is here: Analogue Scorecard.xlsx
Thanks in advance!
Olly.