G Guest Jun 16, 2005 #1 I would like a column in my Excel spreadsheet to be made bold once the dates in that column are more than 29 days old.
I would like a column in my Excel spreadsheet to be made bold once the dates in that column are more than 29 days old.
B Bob Phillips Jun 16, 2005 #2 Use conditional formatting in say A1:A100 with a formula of =A1<TODAY()-29 -- HTH RP (remove nothere from the email address if mailing direct)
Use conditional formatting in say A1:A100 with a formula of =A1<TODAY()-29 -- HTH RP (remove nothere from the email address if mailing direct)
D Dave Peterson Jun 16, 2005 #3 One way is to use Format|Conditional formatting. Cell Value is Less Than =today()-29 (use the dropdowns for the first two and type the last.) And give it a nice old format.
One way is to use Format|Conditional formatting. Cell Value is Less Than =today()-29 (use the dropdowns for the first two and type the last.) And give it a nice old format.
