Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel 2007 conditional formatting

  Asked By: Alison    Date: Nov 23    Category: MS Office    Views: 1120
  

i have a table with 4 columns of numbers, and want the lowest number in the column that is greater than zero highlighted. the table has a lot of zeroes that need to be ignored.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Harish Gupta     Answered On: Nov 02

Hi,
Here is how you how you can do it,
Let us assume that the 4 column of numbers are in Column A:D,
In Cell A2, Below is the formula you can write in conditional formatting
=SMALL($A2:$D2,COUNTIF($A2:$D2,"0")+1)=A2
Once done, You can use format painter and roll the rule to all the cells.
Hope this helps,
Regards,
Harish Gupta

 
Didn't find what you were looking for? Find more on Excel 2007 conditional formatting Or get search suggestion and latest updates.




Tagged: