hai
I am attaching a file containing date and qty.
I want CONDITIONAL FORMATING (Dec 2015 & Jan 2015 ) with Qty coloured.
With out VBA code if possible.
hai
I am attaching a file containing date and qty.
I want CONDITIONAL FORMATING (Dec 2015 & Jan 2015 ) with Qty coloured.
With out VBA code if possible.
Try in cf rules this.
=OR(AND(MONTH($C4)=1,YEAR($C4)=2016),MONTH($C4)=12,YEAR($C4)=2015)
Celect C4:D42 then apply =AND($C4>DATEVALUE("30/11/2015"),$C4<DATEVALUE("01/02/2016")) as CF
thanks sir i am trying
thank q sir it works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks