how to do it?

G

Geald Baalhuis

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???
 
G

Gord Dibben

Gerald

Have you given a thought to Conditional Formatting?

Format>CF>Formula is =SUM(B1:X1)>A1

Format to a nice color.


Gord Dibben Excel MVP
 
Top