Hi David

Yes I have tried the various replies but have not been able to work any of
them into my document.

Column C has dates written in and depending on the date it changes colour so
red for 10 days past, amber for 5 days past and green for any dates in the
future.

What I would like to do is when the date is typed in I not only want that
cell to change colour I also want four cells, A1, B1, C1(date), D1 to change
to the same colour as C1.

Does that make any more sense??

Thanks

Sara

"David Biddulph" wrote:

You're going to have to give us more information than that if you want us to
help you. What conditional formatting conditions do you have in which
cells, what data values do you have in the cells which affect the conditions
you are using, what formatting did it give you, and what did you expect?
Did you read the various replies to your earlier question, and did you try
them?
--
David Biddulph

"Sara" wrote in message
...
Hi

I have looked at this but am unable to work it any ideas??

Thanks for your help.

Sara

"Don Guillett" wrote:


Use the format painter

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sara" wrote in message
...
Sorry it's a bit more complicated the conditional formatting means that
depending on which date you enter the cell goes red, green or amber -
it
is
when the date is typed in and the cell chnages colour I want three
other
cells on that row to change to that colour - the info in those cells
will
already be typed in and does not relate to the colour.

"Sara" wrote:

I have used conditional formatting in a certain coloumn so colour
changes
depending on input I now need rest of row to change to same colour ??