Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Read the link that Bob provided... that is probably more along the lines of
what you are after than what I assumed in my posting. Rick "Rick Rothstein (MVP - VB)" wrote in message ... Something like this maybe (change the cell reference and what you are returning the Yes/No to to suit your needs)... If Range("A1").Interior.ColorIndex < 0 Then Answer = "No" Else Answer = "Yes" End If Rick "Helen" wrote in message ... I have a spreadsheet that is colour coded, and I want to be able to return a yes or no based on whether the cell is coloured in or not. I'm trying to use If Then with FormatConditions.Colorindex but it's not working. Many thanks Helen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I customise colours used in charts and keep those colours. | Charts and Charting in Excel | |||
How to save one of the MORE COLOURS in the THEME COLOURS? | Excel Discussion (Misc queries) | |||
Can I change the colours on a spreadsheet with an if formula? | Excel Programming | |||
How to use Add Ins / Formula Colours | Excel Discussion (Misc queries) | |||
Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) |