Is there a way to color the cells based on the numeric value?

You can use CF

See
http://www.contextures.com/xlCondFormat01.html


--
Regards Ron de Bruin
http://www.rondebruin.nl


"ajyourpal" <[email protected]> wrote in message news:[email protected]...
> How can I set up my worksheet so that the color of the cell will change based
> on the value in that cell? For example, if the numeric value is 7, the color
> of the cell will be red.
>
> Any suggestions?

How can I set up my worksheet so that the color of the cell will change based
on the value in that cell? For example, if the numeric value is 7, the color
of the cell will be red.

Any suggestions?

You can use CF

See
http://www.contextures.com/xlCondFormat01.html


--
Regards Ron de Bruin
http://www.rondebruin.nl


"ajyourpal" <[email protected]> wrote in message news:[email protected]...
> How can I set up my worksheet so that the color of the cell will change based
> on the value in that cell? For example, if the numeric value is 7, the color
> of the cell will be red.
>
> Any suggestions?