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. |
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. |
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