Conditional formatting using an index formula

George77

New Member
Joined
Nov 15, 2016
Messages
8
Hi,
I have used the formula below to apply conditional formatting to the cells in my worksheet. The conditional formatting is based on the result of inputting a value in the column heading and a value in the row headings. The problem I have is that all results are the same colour. I need the colour to be different based on each value in the row headings A9:A15

=INDEX(C9:CR15,MATCH(CV10,A9:A15,0),MATCH(CV12,C1:CT1,0))
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,440
Office Version
365
Platform
Windows
You will need a new rule for each colour.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,440
Office Version
365
Platform
Windows
You're welcome
 

Forum statistics

Threads
1,082,585
Messages
5,366,466
Members
400,892
Latest member
lamarh755

Some videos you may like

This Week's Hot Topics

Top