Forum Discussion
Solved
How can I change the cell colour of one cell based on either another cells' colour OR value?
Hey guys! Working on a personal study tracker, and would really appreciate any guidance/support on this step I'm trying to setup. Note: - Cells from Column D12 onwards below = date - Cel...
- Thank you so much for your prompt response, Sergei! This is EXACTLY what I was looking for! Cannot thank you enough my friend, this was bugging me for some time!
P.S. to anyone reading, what Sergei has done: select cells D12:D21 (date column in this example)>Home>Conditional Formatting>New Rule>"Use a Formula to determine which cells to format">Input the formula in image>Done
AND, marry this with what I mentioned earlier with the conditional formatting for column E based on cell-value, and we have a synchronised cell-colour change based on cell value!
Thank you again, Sergei! 🙏UA_131 , you are welcome and thank you for so great feedback.
- sergej our savior 🙂 !!
