Thankyou very much for your help but i have more questions. The first answer you gave is the result i want but i want the colour change to affect a different cell. for your second answer I dont know where to write the code or what bits to change.
The cell that needs changing to red is b4 and...
Is there a way to change the colour of one cell based on the input of a different cell. My database needs to have colour coded cells and i have no idea how to do it. Please help.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.