Thanks (yet again) Don
I just assumed Richard Schollar would have pointed out that his solution was in fact VBa.
The thread title was "Use Cell Color In Formula Without VBA"
I must confess I had not read Chips' webpage fully when I posted.
I'll reconsider that reply,on reflection.
The short answer is no.
[EDIT]
An updated workbook is available here
http://www.excelforum.com/excel-gene...ml#post2377147
Bookmarks