I want to apply conditional color scale but it doesn't work. This is the original cell (A12)in a sheet called
Then, I use in B4:
to convert it to only numbers, so I have
2074 in the cell.
But it doesn't work with the conditional color scale. It only works if I write the number manually, and that isn't useful for me.