can I condition format cells that are not joined together in a worksheet when I enter a figure.
Lets say I have 280 cells and cell 1 is D6 and it goes down to Cell 40 = D48. Cell 41 = G6 to Cell 80 = G48. Cell 81 = J6 down to Cell 120 = J48.
How do i condition the cells so the colour changes when I enter a figure to represent the amount of boxes I need?
Lets say I have 280 cells and cell 1 is D6 and it goes down to Cell 40 = D48. Cell 41 = G6 to Cell 80 = G48. Cell 81 = J6 down to Cell 120 = J48.
How do i condition the cells so the colour changes when I enter a figure to represent the amount of boxes I need?