Conditional Format Q

  • Thread starter Thread starter Seanie
  • Start date Start date
S

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?
 
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
 
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 ="
 
Thanks Rick, I tried almost everthing except your last post and
couldn't tweak it to get it to work
 
Back
Top