<div>
2003 doesn't support cross sheet checking for Conditional formatting but you can get round it by giving the cell that you want to look at for the comparison a RangeName eg CheckCell.<br />
<br />
The formula for the CF in cell B2 would then be:<br />
<br />
=$A$2=CheckCell<br />
<br />
Thanks<br />
Rob H
</div>


2003 doesn't support cross sheet checking for Conditional formatting but you can get round it by giving the cell that you want to look at for the comparison a RangeName eg CheckCell.

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

=$A$2=CheckCell

Thanks
Rob H

Conditional-Formatting-check.xls

<div>
<div class="content wysiwyg-content">
Hi Experts (excel 2003)<br />
<br />
I need a conditional formating formula to do the following:<br />
<br />
If cell A2 in sheet ABC equal Cell A2 in sheet Apples the in cell B2 Sheet ABC green other wise red....
</div>
</div>


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

conditional formating formula between two worksheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.