Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Q
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Q
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 =" -- Rick (MVP - Excel) "Seanie" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Q
Thanks Rick, I tried almost everthing except your last post and
couldn't tweak it to get it to work |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |