Re: If a column contains only 1 lowest score...

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Pete_UK <pashurst@xxxxxxxxxxx>
Date: Wed, 04 Jul 2007 13:12:31 -0700

What do you mean by "lowest value"? Do you mean if there is only one
minimum in the range then colour it, but if there are, say, 3 cells
which are all minima then don't bother?

Pete

On Jul 4, 8:58 pm, JerryW <Jer...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Please help me do the following...

If a column data contains only 1 "lowest value", then change that cell
"background color" to "yellow" and the font to "red bold", else do "nothing".

Follow-Ups:
- Re: If a column contains only 1 lowest score...
  - From: T. Valko

Prev by Date: Re: How to determine the formula to generate following numbers?
Next by Date: Re: Multiplying non consecutive rows, than adding it.
Previous by thread: Re: Multiplying non consecutive rows, than adding it.
Next by thread: Re: If a column contains only 1 lowest score...
Index(es):
- Date
- Thread

Relevant Pages

Re: Open Letter to Peter Seibel [was Re: Lisp and software architecture]
... only downside is if I decide screw you guys, ... I just explaind why it was thta I never bothered to look deeply into ... And I cannot believe you did not explain how what I posted did not address both what Cells is and why you should bother. ...
(comp.lang.lisp)
Re: Open Letter to Peter Seibel
... tutorial is now up to date:) <ducks> ... Cells, in response to your claim that it was because I was unable to ... that you could not find anything explaining what it was and why you ... what Cells is and why you should bother. ...
(comp.lang.lisp)
Re: is this possible?
... bother to look and it doesn't do much for archives for those who follow with ... I am trying to get Excel to copy content of some cells to next sheets, ...
(microsoft.public.excel)
Re: How do I keep apparent table width independent of window size?
... But perhaps this will give you a thought to play with: ... bother with giving the table itself a width, ... either all the cells or selected cells (by classing them is most ... I'm surprised setting a width on the whole table didn't work as intended ...
(comp.infosystems.www.authoring.html)
Re: Set Range.....am I to blind?
... fact, if you would and when you have time, briefly explain the why bother to ... I thought the cells() in the range object are just for the addresses ... Who is the parent of your Cellscalls? ...
(microsoft.public.excel.programming)