02-05-2017, 03:45 AM
Hello,
Would it be possible to add in "Advanced cards":
a) a boss milestone dropdown with conditonal formating rules:
b) in range L37:Z37 a formula that calculates how many card packs are needed to reach milestone goal. So the fomula in L37 looks like: =L34/$Q$18
Would it be possible to add in "Advanced cards":
a) a boss milestone dropdown with conditonal formating rules:
Code:
Apply to range: F4,K4,F6,K6,F8,K8,P8,U8,F10,K10,P10,F12,K12,P12,F14,K14,F16,K16,F18,K18,F20,K20,P20,U20,Z20,F22,K22,P22,U22,Z22,F24,K24,P24,U24
Custom formula is: =F4<$M$1
($M$1 is where i have the boss dropdown)
b) in range L37:Z37 a formula that calculates how many card packs are needed to reach milestone goal. So the fomula in L37 looks like: =L34/$Q$18