| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: How do I use IF formula with colours
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA: How do I use IF formula with colours
If Cells(1, 1).Interior.ColorIndex = 1 Then
-or- If Cells(1, 1).Font.ColorIndex = 1 Then "Helen" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I use IF formula with colours
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I use IF formula with colours
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I use IF formula with colours
See http://www.xldynamic.com/source/xld.CFConditions.html but it is not
simple. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "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 | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
