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