ExcelBanter - can i link a cell to a calendar so it will auto update

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

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

- - can i link a cell to a calendar so it will auto update (https://www.excelbanter.com/excel-discussion-misc-queries/30864-can-i-link-cell-calendar-so-will-auto-update.html)

paulyoung666

can i link a cell to a calendar so it will auto update

i am trying to get a cell to change font color when it passes a certain date

SVC

Format Conditional Formatting, Cell value is greater than [date]
Select Format and change text color to desired color

"paulyoung666" wrote:

i am trying to get a cell to change font color when it passes a certain date

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