I have the following dataset, which changes during the day:

[dataset](https://i.stack.imgur.com/17ivf.png)

On row 3 I successfully use conditional formatting to color cells depending on the value in row 2.

Example of conditional formatting in my sheet: Color cell A3 cell red if:

=A$2 3<=MAX(B2:M2)

My problem is:

How do I use this MAX function if I want it to only use cells between B2:M2, where the cells above them B1:M1 contain text?

Help is much appreciated!

I tried creating arrays, but using ctrl enter when using conditional formattin doesn't seem to work

CodePudding user response：

1.Select B3:E12. 2.Select Home, Conditional Formatting, New Rule. 3.In the New Formatting Rule dialog, choose “Use a formula to determine which cells to format.” 4.Type =B3=MAX($B3:$E3) in the dialog box. 5.Click the Format… button. 6.In the Format Cells dialog, click the Fill tab and choose a fill color. 7.Click OK to close the Format Cells dialog. 8.Click OK to close the New Formatting Rule.

CodePudding user response：

Solved by user PB in comment section of my post. Thanks!!