using cell formating in the if statement

Microsoft Excel 2007
January 13, 2010 at 08:59:26
Specs: Windows XP
i have a range of numbers and i want to use the if statemetn to cahnge the color of the cell with the lowest value in this range.

See More: using cell formating in the if statement

January 13, 2010 at 09:49:40
Without more specific info, all I can suggest is that you explore Conditional Formatting


Report •

January 13, 2010 at 12:49:44
A cell based formula cannot change the color of a cell.

You can try an IF statement with Conditional Formatting:

For example, select A1:A4 and put this formula in the Formula Is.. field under Format...Conditional Formatting, then select your pattern color.


This will format the cell (or cells) which is the MIN of that rnage.

Report •
Related Solutions

Ask Question