conditional formatting between worksheets

I have previously submitted a thread along similar lines but did not get a solution, so I hope I can make my requirements clearer this time. Basically I have quite a complicated (well complicated for me!) conditionaly formatted cell on sheet 2 which changes colour triggered automatically by its proximity to a specific date, I am trying to get a cell on sheet 1 to detect that and also change colour. I have managed to get close by naming the cell on sheet 2 but that only works with numerical values, the cell being monitored just changes colour and I cant figure out how to assign a value to it when it does. Any advise with this would be greatly appreciated. Regards Nigel.

can you not apply the same conditional formating to both cells? if you name the cell on the second sheet, and use formula is on the first sheet using the cell name rather than reference? So that the cell on the first sheet changes when the same conditions are met as the cell on the second sheet

it works with text for me

why not post an example

Regards

Dav

Thanks for the repy Dav....here is the formula I have devised for a cell on sheet 2...

IF(AND(F8="m"),TODAY()-E6>=H8-30,IF(AND(F8="c"),TODAY()-E5>=H8+30,IF(AND(F8="b"),TODAY()-E4>=H8-30,IF(AND(F8="a"),TODAY()-E3>=H8-30))))

I hope Ive copied that down correctly...can you show me how I would add a name reference to that on sheet 1?

Thanks in anticipation

Nigel

Many thanks Dav.....I will try that today and let you know how I get on.

Regards

Nigel