| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Any IF(A2=font color=red", "1", "0") in excel? Or a way to do it?
|
|
#2
|
|||
|
|||
|
Any IF(A2=font color=red", "1", "0") in excel? Or a way to do it?
Function GetColorindex(rng As Range)
GetColindex = rng.Interior.Colorindex End Function =If(GetColorindex(A2)=3,1,0) -- HTH RP (remove nothere from the email address if mailing direct) "Steve" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Add-in: Open Database Connectivity available for Excel | Excel Discussion (Misc queries) | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
| "Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Hybrid Mode
