ExcelBanter - how do i flag a cell using background color

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i flag a cell using background color (https://www.excelbanter.com/excel-worksheet-functions/106310-how-do-i-flag-cell-using-background-color.html)

Heather

how do i flag a cell using background color

I need to know how to change the background color of a cell based on data
entered. Such as a date that is more than a year the background of that cell
turn red.

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