#16
|
|||
|
|||
Ok your correct it works. I was having issues due to the single quote still being in the formula ( which you are correct it is no longer required). I knew formulas auto adjusted within the sheet but never realised conditional formating did the same. Thanks for all your help and how to i list thread as sovled? |
#17
|
|||
|
|||
Good question. I don't remember.
|
Tags |
concatenated data |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formating | MaineLady | Excel | 2 | 10-30-2016 02:08 PM |
Conditional Formating | Aseren | Excel | 14 | 02-18-2016 01:05 PM |
Copying Conditional Formating | lynette | Excel | 2 | 03-06-2015 11:53 AM |
Conditional Formating | MaineLady | Excel | 1 | 11-05-2014 06:37 PM |
more Conditional Formating | princeofsadness | Excel | 2 | 09-05-2011 02:14 AM |