Lookup / IF function - looking up colours

[NestorDave]

Can anyone help? Is it possible to do a lookup or IF function to look at the colour of a cell. ie - IF this cell is red, then add it, IF this cell is green, then add it, etc....

Cheers

 

[al_b_cnu]

Hi, Welcome to the board.

This link might help http://www.cpearson.com/excel/colors.htm