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!

 

[ken2step]

Post your conditional format formula or condition and let us see if we can help!

 

[mona4]

The conditional formatting formula:

Formula is=CommentText(J1,"splits resolved")

This is formatted to background highlight light green, it works in one workbook but not the one i have pasted the column too.

 

[ken2step]

Surely that is not it.....
=Comment Text(J1,"splits resolved") is not any function I know of. Can you be more specific please?

 

[mona4]

It definitely is, it is a formula that makes any row with a specific comment to highlight depending on ur condition set. A comment as in Insert|Comment.

 

[ken2step]

Never heard of it....sorry can not help...but I will watch and learn!!

 

[rbraxton]

[good formula, I'll remember that one]

1. In your new (copied to) workbook, go in and check your entire CF'd range for broken references.

2. If thats not it, ...has your new workbook any pre-existing formatting you don't know about. If so, you may need (and try) to delete all the blank columns to the right, (or all the blank rows...all the way to 65,536!).
This sometimes works when trying to fix a mysterious CF problem.

3. Note: make sure you've checked for any slight variations in the CF or the value it is written to respond to. (Even the most meticulous person -- that would be me...lol -- can miss a minor flaw occasionally.)

Thanks,
Rob

 

[mona4]

thanks for the suggestions, tries all the checks, but still not working, completely baffled on this one

 

[leibale]

first chk in the new workbook, if the reference (j1) is the correct.
also, chk if the new workbook know this function.
write it on a cell to see if u get #NAME error

 

[mona4]

The cell says true or false depending but not name error, so yes it is working in that way but still not highlighting