My worksheet contains Date in A1, and some number fields in B1, C1, D1, E1 After enter date in A2 it has to compare with date in A1 and if it is within 3 months then it have to lock B2, C2, cells and copy the values from B1 C1 to B2, C2 and change font color and cell color of B2 & C2.
Is it possible with single "If" function, or I have to write macro for this.
Please answer on IF & Macro for this
Thanking you
Bookmarks