Hi,
I would like excel to colour in a range of cells a certain colour depending on the value of the cell.
For example, if B2 = Yes, colour B2 to G2 Yellow. If B2 = No colour B2 to G2 Red. etc. (5+ conditions so conditional formatting isn't good enough)
Additionally there are scenarios where I want [If b2 is Yes AND c2 is Yes then colour b2 to g2 blue, otherwise use the above conditions]
This is what i have at the moment, it doesn't seem to work unless the values are number based, it doesn't do a range of cells, and I don't have the additional scenarios. Amateur hour.
Thanks in advance!
Bookmarks