conditional formatting based on values

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

ChrisBat

Hi,

(Also posted on the Programming 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
 
I haven't tried this but it works for Data Valadation. Try naming the cell
in the other sheet and using the range name in the conditional formating
formula.

The help for Data Valadation states you can't use a list in another sheet.
However, it will accept a range name that references a list in a nother
sheet.

- John Michl
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting and programming??? 2
Excel 2007 Conditional Formatting problem 8
Cell values to an array, then array transpose to another workbook 8
Comparison of columns using Conditional Formatting 3
Fill a cell based on a condition being met 3
Array across multiple worksheets 1
Validation based on values 1
Conditional Formatting - 2 columns 2

Back
Top