Excel07 does not support conditional formatting on multiple sheets

[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

 

[Nickole B.]

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.

 

[Vanita]

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.