How to create a "what if color is" formula

[stormracela]

I want my cell to return "True" if the color of cell is red and "False" if the color of cell is yellow.

How can I create a formula with this condition?

IF Column A= red, then Column B= "True"
IF Column A= yellow, then Column B= "False"

Thanks in advance!

[Palmetto]

How can I create a formula with this condition?

Excel does not provide a built-in formula to check the color of a cell. You would have to use VBA code.

However, if your colored cells are having their fill color set using Conditional Formatting then you can use the same condition in a formula.

Example:

If cells in column-A turn "red" when they contain the value of 1, then in column-B you could us a formula like: =if(A1=1,"True","")