Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Colours in Excel 2007

  Asked By: Aditi    Date: Mar 05    Category: MS Office    Views: 677
  

I am trying to find the colour code numbers in Excel 2007, which are
backwards compatible with e.g. Excel 2003.

Example
Selection.Interior.Color = 3 'red cell
Selection.Font.Color = 2 'white font

When running this code, it makes both the cell background and font
colour black. This is due to the increased number of colours in Excel
2007 and each colour starting at the very low end of the colour
spectrum. I'd like to know if there's a way of using true colours like
in Excel 2003.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Devin Ross     Answered On: Mar 05

It is also because you are setting the Color property to a Colorindex
number.

 
Didn't find what you were looking for? Find more on Colours in Excel 2007 Or get search suggestion and latest updates.




Tagged: