Multiple conditional formatting

[sibilare]

I have five columns (years) and I want to format the highest number colour green

and

to check the five columns if any is over 400, colour code the first column orange (ignore the green)

Thanks in advance.

 

[Fluff]

Hi & welcome to MrExcel.
Do you want to highlight the highest value in each column or just the highest value overall?
Also if a value is over 400, do you just want to highlight that row in the first column?

 

[sibilare]

Hi & welcome to MrExcel.
Do you want to highlight the highest value in each column or just the highest value overall?
Also if a value is over 400, do you just want to highlight that row in the first column?

The highest value in blue for the row 1 compared to the five columns.

Column b-f compared
Rows shown as "1-"

row 2 would be Cell F - 2 would be highlighted green
row 3 would be have cell B - 3 would be highlighted orange Even though F - 3 is a higher number it is not highlighted green.

eg

a
1- b c d e f
2- 21 56 79 1 100
3- 400 123 300 200 401

 

[Fluff]

Is this what you want?

Excel 2013/2016
	B	C	D	E	F
2	101	95	96	97	98
3	105	106	107	108	109
4	77	99	75	76	77
5	67	68	69	70	71
6	78	79	299	300	198
7	85	86	87	88	89
8	83	84	85	400	401
9	111	112	113	114	115
10	117	118	119	120	121
Sheet2

 

[Fluff]

If the above is what you're looking for.
Select B2:F33 & use this formula for the green format
=AND(B2=MAX($B2:$F2),MAX($B2:$F2)<400)
Then select B2:B33 & use
=MAX($B2:$F2)>=400

Change the F33 & B33 to reflect the last row number of your data.