I've got a simple conditional formula to make cell green if there is more than X not empty fields. It works fine but I need a way to copy that formula to other columns. When I do it the simply click and drag way, it copies the formula but is still based on values from column D.
I want it to be like: Colour green if there is more not empty values in column X than specified in cell X21. Colour green if there is more not empty values in column Y than specified in cell Y21. etc.