Need the formula or macro. If i enter today date in the cell (Row 1,Column 2) and on tab out, the column 1 cell should be filled with "corresponding Day" of the date
If i enter today date in the cell (Row 1,Column 2) and on tab out, the
column 1 cell should be filled with "corresponding Day" of the date
In a spread sheet, for a complete month i have some comments are
filled,
The rows should be colored to red,the content in the cells should be
Italized and striked, when the date is less than current date
The rows should be colored to Green, the contents should be bold, when
the date is equal to current date
The rows should be colored to Blue, when the date is more to current
date
Thanks
kakasay
|