Use a cell formatted color background as a condition

[EDOFRED]

I would like to know if there is any way to use the the background color of a cell as part of the IF function.

I am interested in something like:
- IF (cell background color is red), then calculate this, else that)

I cannot find any criteria or attribute description to check the background color of a cell.

thanks
Edoardo

 

[Oaktree]

Welcome to the board.

There is no embedded formula in Excel to do this, however you can use the UDFs (user defined functions) Chip Pearson lists here:

http://www.cpearson.com/excel/colors.htm

 

[USPS EMPLOYEE]

Sent you a PM that may do the trick.