View Single Post
  #7   Report Post  
Roger Govier
 
Posts: n/a
Default

Hi Maggie

In the cell value scenario, the formatting will only change if the condition
of that cell meets the criteria set.

In the Formula Is scenario, the same happens to be true (in your case)
because the criteria contains the cell name as part of the criteria set.
But equally you could set a cell to change format based upon the results of
criteria relating to an entirely different set of cells.

e.g. You might want the heading to become bold red if there are more than a
certain number of entries in the column.

Regards

Roger Govier


MaggieMagill wrote:
bill k wrote in
:


highlight the range and under conditional formatting select
<cell value<is equal to
and enter in the right hand block =Max($A$2:$A$51)
then set the format.....

similar for the minimum




Thank you all for the responses! Works perfect! I guess my biggest problem
was not using absolute references for the range.

But I'm curious - two different solutions were offered and both seem to
work for what I need. Why does one version (suggested twice) include the
relative reference to the first cell in the range?

Oh wait - I see one is "formula is" the other "cell value is". So what I
see is that the "formula is" version is basicaly
={cell value is}=Max(abs range).

So now my question is (in trying to understand the function better) if the
=MAX($A$2:$A$51) can be applied to each cell in the range for the
condition, is there any benefit in applying it as a formula that contains
that relative cell's value to compare with the function within the formula?

Am I correct in seeing the "formula is" version as an added wrapper or
redundancy of sorts?

Don't mind my question - I'm just trying to figure out the "formula logic"
Excel uses. It's an academic question as both provide the desired results!