Simplify multiple conditional formats

[ollyhughes1982]

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.

 

[Fluff]

Try selecting L26:P31 & use this formula

=INDEX('All Completed Runs - Alphabet'!$C$4:$C$29,MATCH(L26,'All Completed Runs - Alphabet'!$A$4:$A$29,0))<>""

 

[ollyhughes1982]

Great, will try that now. Also, would it still work if I expanded the range downwards, or would I need to keep each line separate?

 

[Fluff]

I don't understand what you mean about expanding the range. There are only 26 letters of the Alphabet

 

[ollyhughes1982]

Sorry, I meant so that the condition applies to a range including all of the 6 rows, rather than just the A-E in the example I gave. I realise now, I can do that by just adding each line as a range, separated by commas in the 'Applies to' field. Thanks again, it works perfectly.

 

[Fluff]

You don't need to change the applies to range if you did what I suggested.