Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF in between rows | Excel Worksheet Functions | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |