Working with Conditional Formatting

[Mommom]

I have a workbook that has several worksheets. I created conditional formatting. Basically 1-40 is green 41-79 is yellow and 80-100 is red. In one worksheet in the field it could be all three. My dilema is on my main workbook I want it to be set up that if any information on the circuits worksheet is red then I want it to make the main workbook next to the circuits box to also turn red. I know how to do it for one cell but not for multiple cells.

Any help is appreciated.

Thanks,

 

[SteveO59L]

As far as I am aware, Conditional formatting canot reference other worksheets

 

[Mommom]

It can reference another worksheet when you are referencing individual cells.

But I want it to refence an entire worksheet. Not sure if that can happen.