How to use if statement/formula based on cell color in Microsoft Excel

Subscribe to my channel and unlock exclusive benefits!

There is no built-in formula in Microsoft Excel that can determine the color of a cell. If you need to use an IF statement formula that interacts with cell color, you will need to create a custom macro.

[armycop]

Hello, i have four colors in a data table with other cells that are no fill (uncoloured). i would to sort horizontally colours which are in pairs, i mean two or three cells having colours horizontally which stick together. How can i do that please?

[manojbula]

hi can you help to find a formula to color a font in a cell, as same as in other cell background color?

[sgui]

just inputing that function does not work.
you have created a macro that you did not mention.
is that correct?

[englishforever]

Pedro from Brazil here. What about this: If D5>250 A5 is painted red. I've been thinking about this, and I can't find a solution for it. hahaha

[EyeIn_The_Sky]

is there a way to get a "True" or "False" value by comparing the colour of 2 different cells? For Example, if Cell A1 and B1 are both filled in with Red then cell C1 should say "Match" or "True"? That works for cells coloured by conditional formatting ?

[arqmark]

What about the rest of the colors? Does your addon also cover any other RGB color?

[vivekmusafir]

Thank you so much for bringing this up...this gives me hope as I have a situation where you may be able to help me...I maintain data of some line items on monthly basis and mapping is done in one column being colored red, orange or green basis some numbers...Now I want to compare data with next month and I want to identify how many moved from red to orange/green or vise versa...have been doing it doing manual filter..can you suggest some formula where I'll get input on those transitions so that improvement etc. Can be measured at once...thnx.