Thread: 2003 colors not recognised in 2007??

Hello,

I've just started to use excel 2007 after 2003 usage (pain). It seems that the colour palette has changed. which is causing me problems.

My issue is that the bright red (formerly 36) is no longer on the standard colours and the red that looks a lot like it is number -16776961

The macro that I had created will not change a cell's colour if it is red (36), so obvioulsy does not recognise any cells coloured in the new palette numbering. When I try to get it to recognise -16776961, the macro just skips the line.

Can I either get the 2007 excel to recognise -16776961 in the macro, or get it to just call the red number 36 instead of -16776961 ?


The particular part of code that doesn't seem to be working is

For Each c In Selection.Cells
 'If the font is red, then leave as red - take no further action (was 36)
       If c.Font.ColorIndex = -16776961 Then GoTo skipmacro1 Else

In my macro, I also reference other 2003 colours which also have a similar problem (blues, maroon, grey)...is there a simple fix?

I hope this is clear, but please let me know if I need to explain it again

Thanks

See http://en.allexperts.com/q/Excel-105...-palette-1.htm, including the follow-ups.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save