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