### ColorScale formatting based on cells not being formatted

Posted:

**Fri Nov 29, 2019 3:46 pm**Copying Complex Formatting set on range B2-B20 for the cells in A2-A20 is easy. because you can set the formula to just operate on the cells in B2-B20, but active the formatting on A2-A20.

However ......

I'm not sure how (or if), you can do this for ColorScale formatting.

Reason ....

I want to output a fraction. But as an absolute fraction - so say 14/20 or 18/23 (To represent the amount of checks something has passed). Then alongside it I can write the value as a % by just doing =18/23

However ......

I'm not sure how (or if), you can do this for ColorScale formatting.

Reason ....

I want to output a fraction. But as an absolute fraction - so say 14/20 or 18/23 (To represent the amount of checks something has passed). Then alongside it I can write the value as a % by just doing =18/23