All,
I make conditional formatting for cells ,which I want them to show different
collors .
the data for formatting source from another cells in the row1 from same
sheet,
each month ,I need to update the data source and apply to other row to show
collors. Now I want to make the previous row collors unchanged in previous
months ,and start another row cells to show collors with May. how to make it
happen? supposted only updated the data source in the same rows .please
kindly help.