Today Conditional Format

[Andy Roberts]

I have a column which calculated a date based on 3 working days from a date
input into a diff column. What I want to do I have the calculated date
appear bold if that date has passed based on the current date.

For example if I input 01/08/11 the next column calculates 04/08/11 (3
working days). I want the caluclated date to appear bold when I open the
spreadsheet on the 05/08/11 ro show the calculated date has passed.

I can use conditional formatting but can't get the syntax right

Regards

Andy
Win XP Pro
Office 2010

 

[GS]

Andy Roberts presented the following explanation :

I have a column which calculated a date based on 3 working days from a date
input into a diff column. What I want to do I have the calculated date
appear bold if that date has passed based on the current date.

For example if I input 01/08/11 the next column calculates 04/08/11 (3
working days). I want the caluclated date to appear bold when I open the
spreadsheet on the 05/08/11 ro show the calculated date has passed.

I can use conditional formatting but can't get the syntax right

Regards

Andy
Win XP Pro
Office 2010

In the CF dialog choose 'Cell Value is Less than' and type
'="today()"' into the ref edit box.

 

[Rick Rothstein]

[Off topic to this thread]

Garry,

I know the "How to copy non-contiguous columns to a text file" thread is
pretty much dead, so I'm thinking you are not checking it anymore, but I
came up with an idea for a solution and posted some code to it that you (and
the OP who I hope comes back to it) might find interesting.

Rick Rothstein (MVP - Excel)



"GS" wrote in message
Andy Roberts presented the following explanation :

I have a column which calculated a date based on 3 working days from a
date input into a diff column. What I want to do I have the calculated
date appear bold if that date has passed based on the current date.

For example if I input 01/08/11 the next column calculates 04/08/11 (3
working days). I want the caluclated date to appear bold when I open the
spreadsheet on the 05/08/11 ro show the calculated date has passed.

I can use conditional formatting but can't get the syntax right

Regards

Andy
Win XP Pro
Office 2010

In the CF dialog choose 'Cell Value is Less than' and type
'="today()"' into the ref edit box.

 

[GS]

Rick Rothstein used his keyboard to write :

Garry,

I know the "How to copy non-contiguous columns to a text file" thread is
pretty much dead, so I'm thinking you are not checking it anymore, but I came
up with an idea for a solution and posted some code to it that you (and the
OP who I hope comes back to it) might find interesting.

Rick,
I did see your post there and found it to be very interesting, indeed.
I wanted to play with it for a bit before giving you my feedback.
Though it does not address the OP's needs "as is", it looks like a good
candidate for assembling non-contiguous data.

 

[Rick Rothstein]

...Though it does not address the OP's needs "as is"...

We should actually carry this conversation on over in the other thread, so
don't respond to this question until you are ready to respond over there;
however, I'm guessing the OP must have changed her requirements somewhere in
that long and winding thread then, I went with this from her opening
message...

"I would like to copy columns just B and J to a tab-delimited text file."

I think the file my code outputs would be considered a tab-delimited text
file, wouldn't it?

Rick Rothstein (MVP - Excel)

 

[Andy Roberts]

Thnaks Garry

I had tried that but the conditional formatting gets applied whether the
date is before or after today's date. In other words all cells change colour
irrespective of the date.

Do you think this may have something to do with the date format? I am using
dd/mm/yy

Andy

 

[GS]

Thnaks Garry

I had tried that but the conditional formatting gets applied whether the date
is before or after today's date. In other words all cells change colour
irrespective of the date.

Do you think this may have something to do with the date format? I am using
dd/mm/yy

Andy

It probably has more to do with the number of format conditions you
have AND what order they're in. Otherwise, being the only CF condition,
I found it to work exactly as you expected it to.