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!
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.)