Conditional Format Q

[Seanie]

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?

 

[Mike H]

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

 

[Rick Rothstein]

Since the text in A16 doesn't have quote marks in it, wouldn't the
conditional statement just be this?

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

 

[Seanie]

Thanks Rick, I tried almost everthing except your last post and
couldn't tweak it to get it to work