cell colorindex 6 display true or else display false

stevengoh

Active Member
Joined
Nov 5, 2007
Messages
269
hi

=If(A1=colorindex="6","true","false")

Check how to code the above code properly?
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Perhaps

Code:
Function iscol6(r As Range) As Boolean
iscol6 = r.Interior.ColorIndex = 6
End Function
in a regular module. Then on the sheet

=iscolor6(A1)

If you want to check the font instead of the fill change Interior to Font.
 

stevengoh

Active Member
Joined
Nov 5, 2007
Messages
269
hi VoG, I tried but is not working. It display "#name?". Can make it if cell colorindex=6 display "1" or else display "0". I also find the formula cannot be drag to next lower cells. "+" drag it down to the rest of the cells..
 
Last edited:

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

Code:
Function iscol6(r As Range) As Integer
Select Case r.Interior.ColorIndex
    Case 6: iscol6 = 1
    Case Else: iscol6 = 0
End Select
End Function
This worked for me when I dragged it down a column.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,228
Messages
5,509,923
Members
408,764
Latest member
Abdul Matin

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top