Hi
Thanks, It's working, but it does not get updated if I change the formula e.g.
if I add another cell in formula, the added cell do not get filled with
colour? Is
there any way out?

--
Knowldege is Power


"Bernie Deitrick" wrote:

Ajit,

Select the cell with the formula, press Ctrl-[, then click your color fill
button.

HTH,
Bernie
MS Excel MVP


"Ajit Munj" wrote in message
...
Hi Sir,
I want excel to fill the cells with red colour (fill colour)
which are included in formula e.g.
if a1=sum(b2:b5), b2:b5 should get filled with red colour,
if f1=d1+c5+sum(x1:x5), d1,c5 and x1:x5 should get filled with red colour.
Please guide.

--
Knowldege is Power