Excel07 does not support conditional formatting on multiple sheets

  • Thread starter Thread starter Vanita
  • Start date Start date
V

Vanita

I tried doing conditional formatting on multiple shhets in excel 2007. But it
shows this option disabled when multiple sheets are selected. Plz help
 
Make sure your file is NOT shared. It seems that in shared files you can't
play with conditional format. If that isn't the case, I'm not sure.
 
Thanks Nickole- This feature is supported by Excel 2003 instead. In O7, this
feature is disabled now. Don’t know why. But you can try this in excel 07, by
using format painter.
 
Back
Top