route217

asked on

# conditional formating formula between two worksheets

Hi Experts (excel 2003)

I need a conditional formating formula to do the following:

If cell A2 in sheet ABC equal Cell A2 in sheet Apples the in cell B2 Sheet ABC green other wise red....

I need a conditional formating formula to do the following:

If cell A2 in sheet ABC equal Cell A2 in sheet Apples the in cell B2 Sheet ABC green other wise red....

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

The formula for the CF in cell B2 would then be:

=$A$2=CheckCell

Thanks

Rob H