Charles Marcus <[email protected]> writes: >> In the example that I quoted =IF($Cards121.$B$6>$Cards121.$E$6;2, (in >> part) I have clicked on the cell and in the "Find & Replace" box >> searched for 21 and requested change to 12. I have "Current Selection >> only" ticked and a dot in "Formulas" and a dot in "Search Rows". I have >> also tried with "Entire Cells" ticked. I have also tried searching for >> the whole sheet reference $cards121 with no luck either. > >Hi Bruce, > >I have only one suggestion, probably silly... > >Does the sheet number Cards111 exist? If not, it would be an invalid >reference, and maybe the Find function treats it as a 'not found'?
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
