200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I am wanting to know if the following was possible and if so how do I go about it.
I have a spreadsheet and I want it to calculate that if all cells are green then it gives me a yes or tick in the cell required. If all cells do not equal green then it gives me a no or cross in the cell required.
How can I do this. Please note that I have used conditioning formatting for the coloured cells.
Use the same formula[s] which turn[s] the cell colour to green to set the checkmark.
