I don't believe conditional formatting based on a cell's fill color is an option so that leaves only macros.
I'd like to specify a range of cells in which if I type something into any one of those cells, it's fill color will change to "green". If I then change the fill color to "red" it will stay "red" and not still be "green". Any suggestions? Thanks in advance.
I'd like to specify a range of cells in which if I type something into any one of those cells, it's fill color will change to "green". If I then change the fill color to "red" it will stay "red" and not still be "green". Any suggestions? Thanks in advance.