Thread: Cond Format if cell contains Values INSTEAD of a formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Finny388 Finny388 is offline
external usenet poster
  
Posts: 36
Default Cond Format if cell contains Values INSTEAD of a formula
On Aug 27, 9:19 am, Finny388 wrote:
On Aug 25, 11:24 am, Finny388 wrote:



On Aug 24, 1:40 pm, Finny388 wrote:

I cannot figure this out no matter what I do
Every formula it try to apply addresses the RESULT of the formula (as
it should) instead of the value.

any solution much appreciated

thanks

Any help would be great. I need a way to highlight a cell if a text
value has replaced the formula - to know alert this value is not the
formula's doing but the users.

Because either a value or the result of a formula is valid, it is just
very important to make them visually distinct.

thanks

^

Impossible?

Reply With QuoteReply With Quote