Home |
Search |
Today's Posts |
#1
|
|||
|
|||
change of cell coor by software
I want change the color of a row when the date changes to next month by
software |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COLOUR CHANGE IS A CELL | Excel Discussion (Misc queries) | |||
how do i get cell to change colour when text is added to it to hi. | Excel Discussion (Misc queries) | |||
change a function in a workbook without changing every cell | Excel Worksheet Functions | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
Change value in cell every n seconds | Excel Worksheet Functions |