Excel Conditional formatting of results from formula

Occasional Visitor

I am trying to find the lowest 6 values out of a list of 10.

I want to Format the cell with a FILL value one the Lowest values found,

Statement:

=(SMALL(E6:N6,1)+SMALL(E6:N6,2)+SMALL(E6:N6,3)+SMALL(E6:N6,4)+SMALL(E6:N6,5)+SMALL(E6:N6,6)).

How do I format that detect low value cell with a color, say GOLD to show that cell is in the list of 6 values out of 10.

IU know how to conditionally form cells butr cant seem figure out how formulate or catenate the two together..

Win11

Office 365

Any help would be appreciated

Thank You,

Jeff

 

1 Reply

@Fiftyohms 

Select E6:N6.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Format only cells that contain'.

Leave the first drop down set to Cell Value.

Select 'less than or equal to' from the second drop down.

Enter the following formula in the box next to it:

 

=SMALL($E$6:$N$6,6)

 

Click Format...

Activate the Fill tab.

Select the color you want.

Click OK, then click OK again.