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 |
Need the formula or macro. If i enter today date in the cell (Row
The answer to this one is check out conditional formatting of cells
"kakasay" wrote: 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 |
All times are GMT +1. The time now is 06:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com