Prob Reg. Excel Macro..
Closed
Joy
-
Nov 14, 2009 at 06:17 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Nov 14, 2009 at 04:36 PM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Nov 14, 2009 at 04:36 PM
Related:
- Prob Reg. Excel Macro..
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
1 response
sharpman
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
183
Nov 14, 2009 at 04:36 PM
Nov 14, 2009 at 04:36 PM
look at conditional formatting.
highlight the cells that you wish to be red when the date in the cell in question is todays date.
click on conditional formatting/new rules
select 'use a formula to determine which cells to format'
click on the little spreadsheet icon.
click on the cell with the date that you need to use.
put the following formula in the field after the cell reference - in my case =$C$3
so, the field should look like this =$C$3 = today()
click on the spreadsheet icon again.
click on the format button bottom right.
and select the format you wish to appear in the row/cells when the date is today.
click on ok, then apply.
now, test the results by putting todays date in the cell that will have the trigger date in.
hope you can decipher the above :-)
hope it helps
highlight the cells that you wish to be red when the date in the cell in question is todays date.
click on conditional formatting/new rules
select 'use a formula to determine which cells to format'
click on the little spreadsheet icon.
click on the cell with the date that you need to use.
put the following formula in the field after the cell reference - in my case =$C$3
so, the field should look like this =$C$3 = today()
click on the spreadsheet icon again.
click on the format button bottom right.
and select the format you wish to appear in the row/cells when the date is today.
click on ok, then apply.
now, test the results by putting todays date in the cell that will have the trigger date in.
hope you can decipher the above :-)
hope it helps
