In this video I look at performing an IF based on cell colour. We can retrieve the cell colour using GET.CELL a macro function. If this doesn't work see https://youtu.be/u0jGIHHiie0

This video will be useful if you are asking the following questions:

Can you do an IF statement in Excel based on color?
How do I get the cell color value in Excel?
IF cell colour is red, then....
------------------------