Forum Discussion
Colors in an If function
I would like to creat an If statemet based on the color of a cell. For exemple, if A1 hase a light red fill, then i want to reurn the word " ok" in the cell B1, and if it is any other color then return the word "No" in the cell B1.
Any help is greating appreciated.
1 Reply
- The IF function won't be able to do this Dildar. You could use VBA and create a UDF. Your best bet though is to populate these cells with a value (if they don't already have one) and test the value, not the colour. Alan
