Selct F1:H1 and FormatCFFormula is:

=SUM($F1:$H1)<$E1

Format to a nice bright color.

Copy the formatting down as far as you wish.

Or swap around if you want E to be colored.


Gord Dibben MS Excel MVP


On 18 Jan 2007 11:05:42 -0800, "Claudio Silva" wrote:

Yes... it realy dont!

Still waiting for a solution...

¬¬

Claudio Marques
Jon Peltier wrote:
I don't think DV works in this scenario.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Claudio Silva" wrote in message
ps.com...
Dear Andy,

In fact, i´m traying to use it..
But, without success..

I dont know exactly how to use this function with formulas
=(


Andy Morton wrote:
I look for solutions that avoid VB.
Have you tried Excel's built-in Data validation ?
Its's in the Data menu.
Not difficult to understand.
It checks data entered in a cell to see if it's conforms to your criteria.
Not sure that it will work for what you need.

Andy