find text colour of current cell

[excel_problem]

Hi,

I'm using Excel 2003.

I'm writing a vba macro and I'm trying to identify the font colour of a cell.
I want to know what colour is currently visible in the cell.

Below I'm checking to see if the current cell has a font colour of 41 (blue).

If Selection.Font.ColorIndex = 41 Then

This works on a cell without conditional formatting, but doesn't work on a cell with conditional formatting.


So, I tried this then realised, it doesn't tell me what colour is visable, it tells me what colour it would be if the 1st conditional formatting rule was true.

If Selection.FormatConditions(1).Font.ColorIndex = 41 Then


Can anyone please tell me what the code should be?

thanks

[DonkeyOte]

perhaps worth having a read through of: http://www.cpearson.com/excel/CFColors.htm

[excel_problem]

Hi,

Thanks for the link DonkeyOte,
I think I can do what I need now - many thanks

[Marcol]

If you need to use Excel 2007, there are more problems with graded colours.

Have a look at this thread to get an idea of what they might be.

http://www.excelforum.com/excel-2007...r-scale-2.html

Your profile indicates 2003 but it will do no harm to have a look.

[excel_problem]

Hi Marcol,

Thanks for the reply, could be useful - thanks

[snb]

Please Login or Register  to view this content.

or as a function:

Please Login or Register  to view this content.