Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Violet Nelson   on Jan 30 In MS Office Category.

  
Question Answered By: Tomas Thompson   on Jan 30

Note that Excel 2003 allows 3 "layers" of conditional formatting.
Excel 2007 allows a bunch more and also different types of formatting
(icons, gradients, etc). Interestingly I think I found a glitch it
the system. I have my 2007 set to always save in 2003 format by
default. I created a .xls with formatting that SHOULD have work fine
in 2003, but when I emailed it to 2003-users at work the formatting
didn't work.... Just something to keep in mind. If you're using
2007, but sharing your spreadsheets with 2003 users, then makes sure
your setup is even going to work before you spend much time on it...

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on how to change color of row based on dropdown list Or get search suggestion and latest updates.


Tagged: