PC Review


Reply
Thread Tools Rate Thread

Color rows based on date in a cell?

 
 
tbo
Guest
Posts: n/a
 
      9th Dec 2009
Programming question? Hopefully so.
Excel novice here

I would like to color a row yellow at a certain date, then red at another.
This is for a project and the yellow and red correspond to due dates.
Say at 12/11/2009 the row is yellow. At 12/19/2009 it is red.

I would also like to color a row (some color) when a 100% is reached in the
"completed %) cell.

Help is appreciated!
 
Reply With Quote
 
 
 
 
tbo
Guest
Posts: n/a
 
      9th Dec 2009
Ignore, as this is now in General Excel forum,,

"tbo" wrote:

> Programming question? Hopefully so.
> Excel novice here
>
> I would like to color a row yellow at a certain date, then red at another.
> This is for a project and the yellow and red correspond to due dates.
> Say at 12/11/2009 the row is yellow. At 12/19/2009 it is red.
>
> I would also like to color a row (some color) when a 100% is reached in the
> "completed %) cell.
>
> Help is appreciated!

 
Reply With Quote
 
Sergey Poberezovskiy
Guest
Posts: n/a
 
      9th Dec 2009
Look at Conditional Formatting - this is exactly for it is for

"tbo" wrote:

> Programming question? Hopefully so.
> Excel novice here
>
> I would like to color a row yellow at a certain date, then red at another.
> This is for a project and the yellow and red correspond to due dates.
> Say at 12/11/2009 the row is yellow. At 12/19/2009 it is red.
>
> I would also like to color a row (some color) when a 100% is reached in the
> "completed %) cell.
>
> Help is appreciated!

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Color rows based on a cell value pbreslin@bellsouth.net Microsoft Excel Programming 2 6th Jun 2009 07:15 AM
Color cell text based on date =?Utf-8?B?Qnlyb24=?= Microsoft Excel Programming 2 10th Nov 2005 12:56 AM
Change cell color based on date =?Utf-8?B?UlJQMzMz?= Microsoft Excel Programming 8 2nd Mar 2005 05:44 AM
excel: How can I color code rows based on a value in a cell? =?Utf-8?B?UGFya2VyMTMzMw==?= Microsoft Excel Misc 2 1st Feb 2005 10:37 PM
I want to chage a whole rows text color based on single cell valu. =?Utf-8?B?dGhlZGlhbW9uZGZhbQ==?= Microsoft Excel Worksheet Functions 2 12th Jan 2005 12:15 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:19 PM.