Conditional Formatting and programming???

  • Thread starter Thread starter ChrisBat
  • Start date Start date
C

ChrisBat

Hi,

(Also posted on the Worksheet Functions newsgroup)

I'm looking to compare 2 dfferent schedules, same format,
same column and row headers - I just need to compare the
actual shifts people are supposed to be working.
I've written the IF statement =if(revised!D13<>original!
d13,revised!d13,original!d13, which works. The problem is
that I need to then conditionally format the values that
have changed, and I keep getting an error message saying I
can't reference values in other worksheets/books in
conditional fomatting (i've tried both Cell Value is and
Formula is).
Any suggetions????
Thanks,
Chris
 
Hi Chris,

You can use Named Ranges to refernce values in an external worksheet with conditional formatting.

Name at least the values in the sheet external to the sheet with the conditional formatting (I would name both), then use 'Formula is: = revised_x=original_x'

Fonda
 
sweeeeeeeeet............thanks a million - you may have
just saved my job (okay, a little exaggeration, but if it
makes my appreciation apparent, that's all that matters!!)
Happy Tuesday!
Chris
-----Original Message-----
Hi Chris,

You can use Named Ranges to refernce values in an
Click to expand...
external worksheet with conditional formatting.
Name at least the values in the sheet external to the
Click to expand...
sheet with the conditional formatting (I would name both),
then use 'Formula is: = revised_x=original_x'
 
Back
Top