| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I create an "IF" function using cell color as a logical test?
I would like to create an IF funcation using the color of a cell. For example:
If B2=Red, Yes, No Does anyone know if this is possible or if there is another funcation that is similiar and will work. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I create an "IF" function using cell color as a logical test?
http://www.cpearson.com/excel/colors.aspx
Chip Pearson has this solution on his web page. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "JessLynn" escreveu: I would like to create an IF funcation using the color of a cell. For example: If B2=Red, Yes, No Does anyone know if this is possible or if there is another funcation that is similiar and will work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Incorporating Cell color fill in an "if" logical function? | Excel Worksheet Functions | |||
| How do I change the fill color of a cell using an "IF" function | Excel Worksheet Functions | |||
| How create blank cell value as the result of Excel "IF" function? | Excel Worksheet Functions | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| Logical Test comparison using cell color | Excel Discussion (Misc queries) | |||
Linear Mode
