Hello,
Is it possible to change the standard blue colour of cells in column B to a red colour by clicking (some of) the cells once with the left mouse button and afterwards to sort the data in the spreadsheet on the colours in column B, blue cells up, red cells down, or vice versa?
Additional request/challenge: it should not be possible to enter any other data in the cells in column B, only to toggle between the two colours blue and red.
Any ideas?
Thank you in advance,
JohanXL
Is it possible to change the standard blue colour of cells in column B to a red colour by clicking (some of) the cells once with the left mouse button and afterwards to sort the data in the spreadsheet on the colours in column B, blue cells up, red cells down, or vice versa?
Additional request/challenge: it should not be possible to enter any other data in the cells in column B, only to toggle between the two colours blue and red.
Any ideas?
Thank you in advance,
JohanXL