Gerald

Have you given a thought to Conditional Formatting?

FormatCFFormula is =SUM(B1:X1)A1

Format to a nice color.


Gord Dibben Excel MVP

On Thu, 6 Oct 2005 15:08:10 -0500, Geald Baalhuis
<Geald.Baalhuis.1wi0yl_1128632755.7017@excelforu m-nospam.com wrote:


I would like to do the next:

If the value of a range of cells (e.g. b1:x1) exceed the value of a
single cell (e.g. A1), cell A2 has to be marked by a color. If B1:X1<A1
then blank A2 cell.

I know how to compare the range with the single cell and how to give
the cell A2 a color by VBA, but how to combine the two???