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

Рет қаралды 60,867

5 жыл бұрын

Subscribe to my channel and unlock exclusive benefits!
/ @asvexcel
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.
This can be a time-consuming process if you're not familiar with VBA. To save you the hassle, I've developed a colors addon that does exactly this. You can see it in action in the video above. If you find it useful and don't want to spend hours creating this addon yourself, you can purchase my colors addon file here: asvexcel.com/downloads/colors...

Пікірлер: 19

@EyeIn_The_Sky 3 жыл бұрын

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 ?

@ASVExcel 3 жыл бұрын

Yes, that is possible, but you need my addon to identify the colors: albert.solutions/downloads/colors-addon/

@armycop6441 4 жыл бұрын

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?

@ASVExcel 4 жыл бұрын

Hello. Can you describe your problem in more detail with screenshots? You can email me: info@albert.solutions

@manojbula9720 4 жыл бұрын

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

@ASVExcel 4 жыл бұрын

Hello. Excel does not have that formula by default, so it cannot be found.

@vivekmusafir4492 3 жыл бұрын

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.

@ASVExcel Жыл бұрын

Hello. Thank you for the question. It sounds like the addon created by me will help you. There is no default formula in Excel that determines the cell color.

@englishforever 3 жыл бұрын

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

@arqmark Жыл бұрын

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

@ASVExcel Жыл бұрын

No, it doesn't. But thank you for your suggestion!

@sgui8523 Жыл бұрын

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

@ASVExcel Жыл бұрын

Yes. And you can buy the macro on my website.

@Kaybekibele 2 жыл бұрын

I am trying to get 1 or 0

@ASVExcel 11 ай бұрын

In your case, suppose the yellow-colored cell is C1. We have a custom add-on formula =IsYellow that checks if a cell is yellow. If the cell is yellow, it returns "True"; otherwise, it returns "False". This result is displayed in cell B1. If you want to display "1" for "True" and "0" for "False", you can use an IF formula in cell A1. Depending on your locale settings, the formula would be =IF(B1=TRUE;1;0) or =IF(B1=TRUE,1,0). This formula checks the value in cell B1. If it's "True", it displays "1"; if it's "False", it displays "0"