ExcelBanter - Excel 2000 - Highlighting a date.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2000 - Highlighting a date. (https://www.excelbanter.com/excel-discussion-misc-queries/153222-excel-2000-highlighting-date.html)

onequestion

Excel 2000 - Highlighting a date.

Hi,

I have a date in a cell. If this date is within the next 3 months then I
need the cell to be shaded red. And then when the date expires it needs to be
shaded red also...

How can I achieve this? I have Excel 2000 by the way.

Many Thanks

onequestion

Excel 2000 - Highlighting a date.

sorted it now, no worries

"onequestion" wrote:

Hi,

I have a date in a cell. If this date is within the next 3 months then I
need the cell to be shaded red. And then when the date expires it needs to be
shaded red also...

How can I achieve this? I have Excel 2000 by the way.

Many Thanks

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