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: 1436

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

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.



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

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