View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Conditional Format Q

Hi,

If you want to display the quotes you need 3 either end

=A16="""The Equivalent Days under worked by not working a 39hr Week="""

Mike

"Seanie" wrote:

I have the following in a conditional formatting statement and it
doesn't perform as I expect. Within "Formula is" I have :-

="a16=""The Equivalent Days under worked by not working a 39hr Week
="""

The value returned in A16 (which is formula dervied) is "The
Equivalent Days under worked by not working a 39hr Week =" - NB
without the quotes.

What am I doing wrong?