LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 171
Default Change conditional formatting to coloured alternate rows dependent on a change in date?

I have several rows of text with alternate rows coloured blue.

Column A has a date and columns B and C contain text data.

Is there a way to have those alternate rows change colour when the
date changes in Column A?

Below is the text in this new spreadsheet so far, to illustrate. I
have returned or will return library items as per the dates below.
But it would be nice to have the spreadsheet's conditional formatting
change when the date changes in Column A. I manually have the entire
spreadsheet set for blue&white but I realized when I printed out the
sheet today to take with me to the library, that it'll be easier to
have the rows change to one other colour combination so that I have
blocks of blue&white, then, say, yellow+white, blue&white,
yellow&white, etc., down the page. Is it possible to do something
like this programmatically?

Jul.14.2006 CD soundtrack Empire Strikes Back.
Jul.14.2006 CD audiobook Positive Attitude Training.
Jul.15.2006 CD audiobook 1 Minute Millionaire
Jul.15.2006 CD audiobook 7 Steps to Fearless Speaking
Jul.15.2006 CD audiobook Animals, Inc.
Jul.15.2006 CD audiobook The Success Principles

Thanks!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting, change row to certain color Sylvan06 Excel Worksheet Functions 3 April 28th 09 01:42 AM
Conditional formatting - coloured text Jennie Excel Worksheet Functions 8 June 20th 08 03:28 PM
Conditional formatting does not change when values change. ?? Texana Excel Worksheet Functions 4 August 20th 07 12:20 AM
How do I use Conditional Formatting to change pos No to a Neg No Wannabegeek Excel Discussion (Misc queries) 1 August 6th 07 04:49 AM
Can't change font on conditional formatting faustino Dina[_2_] Excel Programming 3 February 19th 04 03:13 PM


All times are GMT +1. The time now is 04:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"