Can you select a range and have the lowest number automatically be
highlighted in red?
thanks!
Can you select a range and have the lowest number automatically be
highlighted in red?
thanks!
Hi
Use conditional formatting, select your range then go to Format/conditional formatting. Select cell value is, equal to, =MIN(your_range) and choose your format.
JG
do you know how to do conditional formatting?
Choose format...conditional formatting....then do "cell value is" "equal to"
=MIN($A$1:$A$15) or whatever your range is.
1. Select the range and name it "myrange" (no quotes).
Press Ctrl+F3 or go to Insert > Name > Define.
2. Go to Format > Conditional Formatting.
3. Select "Formula Is" and put:
=INDIRECT("rc",0)=MIN(myrange)
4. Press the "Format" radio button and format as desired.
HTH
Jason
Atlanta, GA
>-----Original Message-----
>Can you select a range and have the lowest number
automatically be
>highlighted in red?
>thanks!
>.
>
Why not just use the address directly for the activecell?
Select the range (say B12:F92) and with B12 the activecell:
format|conditional formatting
formula is:
=b12=min($b$12:$f$92)
(using the range name would still work and may be easier to decipher later.)
Jason Morin wrote:
>
> 1. Select the range and name it "myrange" (no quotes).
> Press Ctrl+F3 or go to Insert > Name > Define.
> 2. Go to Format > Conditional Formatting.
> 3. Select "Formula Is" and put:
> =INDIRECT("rc",0)=MIN(myrange)
> 4. Press the "Format" radio button and format as desired.
>
> HTH
> Jason
> Atlanta, GA
>
> >-----Original Message-----
> >Can you select a range and have the lowest number
> automatically be
> >highlighted in red?
> >thanks!
> >.
> >
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks