Formatting Cell

[daddyfoxuk]

Hi, hoping someone can help… I’ve used conditional formatting B4 to B28, so the highest cell turns red which is great!! I now need cells next to these to follow the same conditional format but these cells have text in the (Test 1 to Test 9) Basically highlight in red the highest test score, can anyone advise!! So Test should now be red etc... Thanks

 

[Peter_SSs]

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I also suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

I'm assuming that you have merged cells as indicated in my mini sheet below. This is a smaller sample but shows the idea.

23 06 22.xlsm
	A	B	C	D	E	F	G	H	I
1
2
3
4		3	Test1
5		5		Test2
6		8			Test3
7		6				Test4
8
9
CF High

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F7:H7,E6:H6,D5:H5,C4:H4	Expression	=$B4=MAX($B$4:$B$7)	text	NO
B4,B5:C5,B6:D6,B7:E7	Expression	=B4=MAX(B$4:B$7)	text	NO