I’m trying to create conditional formatting based on the following spreadsheet: My intention is that if Space is not empty and Note is, the cell will glow red with anger. I’m using the following formula for the conditional formatting: =and(if(isblank(D2),"FALSE","TRUE"),if(isblank(E2),"TRUE","FALSE")) Looks great, but that only works for cell E2. How […]