I am trying to combine formulas here, to put color on specific cells (out of a specific range) when they are not empty, and when a checkbox in another cell is checked.
Here is what I tried :
D4 is where the checkbox is, and if it is checked, the color must apply on the cells from F4 to AU only is they are not empty! As you can see on the picture below, D column is ticked so the whole range is colored, but I need only where is is written "2" in that line.
Can someone help me?
I tried the IF formula also, but could not get through. Same with AND and using TRUE, or ISBLANK for F4:AU.