ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   I want todays date in my spreadsheet to be red. I also want this. (https://www.excelbanter.com/new-users-excel/21944-i-want-todays-date-my-spreadsheet-red-i-also-want.html)

Leah Wright

I want todays date in my spreadsheet to be red. I also want this.
 
My purpose is to show what is due today. I need the date to change with
every day and be red so I will notice it. How do I do this?


Hi

Have a look at Format/Conditional Formatting.
Select the column you want to format and use
Formula is . . .
and
=D1=TODAY()

--
Andy.


"Leah Wright" wrote in message
...
My purpose is to show what is due today. I need the date to change with
every day and be red so I will notice it. How do I do this?





All times are GMT +1. The time now is 10:13 PM.

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