formula locating max value and to see if the other columns are within -6 from max

[larsahl]

Hello I have a spread sheet with 4 columns presenting values.
By using Max(B1:E1) i will get the max value of those columns.
But then I want to use that max value and check that all those 4 columns with values are not less than -6 from the max value.
And those values is more than -6 will be highlighted.

Tips?

[Special-K]

Select B1:E1

Conditional Formatting
New Rule
Use a formula to determine...

Enter as the formula
=(B1<=(MAX(B1:E1)-6))
and format as necessary

[Special-K]

Select B1:E1

Conditional Formatting
New Rule
Use a formula to determine...

Enter as the formula
=(B1<=(MAX(B1:E1)-6))
and format as necessary