ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. (https://www.excelbanter.com/excel-worksheet-functions/8313-how-use-formula-change-cell-color-according-date-range.html)

terry

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.

Ragdyer

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.



DrB

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.





All times are GMT +1. The time now is 09:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com