Remember Me?

#1
December 26th 04, 03:19 AM
 terry Posts: n/a
HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE.

I'm trying to write a formula that will change cells to a different color
according to a date range given.

#2
December 26th 04, 05:07 AM
 Ragdyer Posts: n/a

Use Conditional Formatting.

Date at start of range in A1.
Date at end of range in A2.

Cells to change color - A3 to K3

Start by selecting A3:K3, then
<Format <Conditional Formatting
Expand the first box, and change to "Formula Is"
Then enter this formula in the next box:

=AND(A3=\$A\$1,A3<=\$A\$2)

Then click on "Format", and select your formats,
Then <OK <OK.

Enter your start and end dates in A1 and A2, and you should be done.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"terry" wrote in message
...
I'm trying to write a formula that will change cells to a different color
according to a date range given.

#3
December 27th 04, 04:07 AM
 DrB Posts: n/a

For numbers being minus or plus ones, I use custom formatting the cells -
[black]0.0;[red]-0.0

Wonder if this could be used with other values or text.

DrB
"terry" wrote in message
...
I'm trying to write a formula that will change cells to a different color
according to a date range given.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post [email protected] Excel Discussion (Misc queries) 1 January 11th 05 08:15 AM Alida Andrews Excel Discussion (Misc queries) 2 January 6th 05 09:02 PM Rich New Users to Excel 2 December 9th 04 02:06 AM Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM Elboo Excel Worksheet Functions 5 November 22nd 04 02:44 PM

All times are GMT +1. The time now is 10:00 PM.