I have this custom VBA function
Public Function concatenatespecial(rng As Range) As String Dim rng1 As Range concatenatespecial = "" For Each rng1 In rng If (Not Rows(rng1.Row).Hidden) And (rng1.Value <> "") And (Not rng1.Interior.ColorIndex = -4142) Then concatenatespecial = concatenatespecial & rng1.Text & "|" End If Next rng1 End Function
It takes all yellow and non blank cells in range and concatenate it with "|".
Problem is that, it works only if these cells are colored manually. When it is colored by conditional formatting, it does not work.
Could you help me with solution?