Going conditonal formatting crazy!

[mona4]

I am very frustrated, pls could someone help me with this. I copied one column that has conditional formatting to another workbook. But it now isnt working, none of the rows are highlighting anymore, any suggestions would be great!

 

[rbraxton]

Its not a formula error.
The formatting is taking place, you just can't see it.

Is this a New workbook you're copying into, or is it old?

(I suspect you need to delete some blank space.)

 

[mona4]

i copied the column into a new workbook and also deleted the space as u suggested

 

[ken2step]

Question about the formula.....does this formula require a special Add-In because all I get is #Name error?

 

[mona4]

Ok, i have cracke it, i pasted this function code into the VB editor for my workbook. It now highlights correctly and should not display any name error!


Sub comments()
End Sub
Function CommentText(Cell As Range, Txt As String) As Boolean
Dim x As Comment
Set x = Cell.Comment
If x Is Nothing Then
CommentText = False
Else
CommentText = x.Text Like "*" & Txt & "*"
End If
End Function

 

[PA HS Teacher]

CommentText is a not a native excel function. It is a user defined function.

UDF's are extremely convenient and can be tailored to meet your needs. Just remember, it is possible for you to be the only person in the world with that exact UDF. In any case your other files will not have the UDF.

So if you copy this to a new workbook you need to copy over the code. Or if you have some functions you use a lot, make your own Add in, or you can put the code in your personal.xls