I'm trying to open a template file and getting the conditional formatting.
In formula1 I'm getting the a wrong value.
For example the first value should be: =AND(B$4=1,D$4="No")
The code returns: =AND(D$4=1,F$4="No")A shift of 2 columns.
Pls note the attached with a sample code and a template.
Kindly note that the matter is urgent for us since we need to send a fix to our client.Thank you