On 2002-05-05 10:50, beastwood wrote:
i want to highlight lowest value on a range of cells say
A1:F1
i dont see an option in the cond formating to do this do i need to type a formula?
On 2002-05-09 20:40, JimH wrote:
When you format the cells using a color for shading, that color displays in the range until you enter values. If your spreadsheet has multiple rows where you apply this formatting, you'll have a large block of cells with color making the spreadsheet unsightly. Is there a way to apply the formatting to the range of cells only when data is present in one or more of the cells?
On 2002-05-09 22:55, JimH wrote:
Yogi,
I'm talking about conditional formatting. I used Aladin's solution from above, but I modified his formula from =A1=MIN($A$1:$F$1) to =A1=MIN($A1:$F1) because it didn't work when I copied it down several rows.
All the cells where I copied the conditional format are green until a value is entered into one of the cells. I'd like to have the cells blank (with no color) until all values are entered in A1 to F1 and the minimum value is determined. I hope this is clear.
On 2002-05-10 09:46, JimH wrote:
Aladin,
This isn't working exactly right. I need it to highlight the lowest value in each row not the lowest value in the entire range.
Thanks,
Jim