change of cell coor by software
I want change the color of a row when the date changes to next month by
software |
select all the rows from 2 onwards till the end of your data, go to format,
conditional formaating. Sleect "Formula Is", and enter the following formula in the box: =month(A2)<month(A1) and click format, patterns tab, and select a color. Assumption. The dates are in column A Mangesh "rajanku" wrote in message ... I want change the color of a row when the date changes to next month by software |
All times are GMT +1. The time now is 12:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com