Conditional formatting question

Godders199

Active Member
Joined
Mar 2, 2017
Messages
293
Office Version
2013
Hello, I have applied conditional formatting to a range ofcells, for example A1 to D1 and the cells are colour coded based on the value.
I am now struggling as the cells in A2 to D2 need to be formattedin the same colour, is there a way to Link the colour format ? SO effectively A1 and A2 would need to be thesame colour, even though the cells hold different data. The colour is dependant purely on value inrow 1
Hope in all my searching I have not missed somethingobvious.

 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
5,636
Office Version
365
Platform
Windows
How are you colour coding row 1
- is it ONE CF rule (which applies different colours)
- is it SEVERAL CF rules (one for each colour)
 
Last edited:

Godders199

Active Member
Joined
Mar 2, 2017
Messages
293
Office Version
2013
How are you colour coding row 1
- is it ONE CF rule (which applies different colours)
- is it SEVERAL CF rules (one for each colour)
Each cell has three options green amber or red, so 3 rules for each cell

thanks
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
5,636
Office Version
365
Platform
Windows
3 rules for each cell
Have you created 3 rules for EACH cell (in your example 3 X A1,B1,C1,D1) = 12 rules
OR
3 rules in total for the whole range A1:D1
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,576
Office Version
365
Platform
Windows
If you select A1:D2 then apply the rules & lock the row number in the formula, it should highlight both rows.
 

Godders199

Active Member
Joined
Mar 2, 2017
Messages
293
Office Version
2013
there are 3 rules for each cell as the criteria differ.so 12 rules
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,576
Office Version
365
Platform
Windows
What are the rules?
 

Watch MrExcel Video

Forum statistics

Threads
1,095,400
Messages
5,444,253
Members
405,278
Latest member
Rashford

This Week's Hot Topics

Top