• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting didn't carry across to 2007 version

E

excel_stuff

Member
Hi listers,

I am working with Excel 2010. I have used conditional formatting rules using simple formulae and a specific RGB color format (to define red, green and amber colours). However, when I sent the file to my colleague, it was all in one colour. Can anyone suggest a solution to this problem please?

Thank you
Shehzad
 
excel_stuff said:
Hi listers,

I am working with Excel 2010. I have used conditional formatting rules using simple formulae and a specific RGB color format (to define red, green and amber colours). However, when I sent the file to my colleague, it was all in one colour. Can anyone suggest a solution to this problem please?

Thank you
Shehzad
Click to expand...
They might have excel 2003 different version.
 
Thanks. Yes, they are using Excel 2007. Now I want to make my file universally accessible. How do I overcome this problem? Thanks
 
Hi ,

I don't think there is any difference between Excel 2007 and Excel 2010 as far as the colors are concerned ; it all depends on how you have specified your colors.

If you can upload your Excel 2010 version file , we can check.

Narayan
 
You must log in or register to reply here.
Back
Top