Forum Discussion
Excel Conditional formatting of results from formula
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)+SMAL...
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.