Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Statements looking at colors?
Can you create a conditional statement that looks at the color of another cell?
For example: I need column BN to look at column AX, if AX is RED, column BN needs to say FALSE. I have too many different values in AX, or I would use an actual value in my conditional statement for column BN. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Statements looking at colors?
You can't do that with one of the standard Excel functions, but it is
relatively easy to devise your own User Defined Function to read the color index of a cell. Bob Phillips show how he http://www.xldynamic.com/source/xld.ColourCounter.html and goes on to give many examples of how you can use such a function. Hope this helps. Pete On Feb 19, 10:44*pm, taurus99 wrote: Can you create a conditional statement that looks at the color of another cell? For example: I need column BN to look at column AX, if AX is RED, column BN needs to say FALSE. I have too many different values in AX, or I would use an actual value in my conditional statement for column BN. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Statements looking at colors?
Thank you for the feedback. However, I read through the information and found
it won't work for me because the colored cells I am working with were colored using conditional formating. UGH! "Pete_UK" wrote: You can't do that with one of the standard Excel functions, but it is relatively easy to devise your own User Defined Function to read the color index of a cell. Bob Phillips show how he http://www.xldynamic.com/source/xld.ColourCounter.html and goes on to give many examples of how you can use such a function. Hope this helps. Pete On Feb 19, 10:44 pm, taurus99 wrote: Can you create a conditional statement that looks at the color of another cell? For example: I need column BN to look at column AX, if AX is RED, column BN needs to say FALSE. I have too many different values in AX, or I would use an actual value in my conditional statement for column BN. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Statements looking at colors?
Well in that case it is possible to use the conditions that you
applied for your CF within the formula. For example, suppose your cells in column AX turn red if their value is above 50 - in BN1 you can put this formula: =AX1<=50 This will return FALSE if AX is above 50 (i.e. red) and TRUE otherwise. Hope this helps. Pete On Feb 20, 1:16*pm, taurus99 wrote: Thank you for the feedback. However, I read through the information and found it won't work for me because the colored cells I am working with were colored using conditional formating. *UGH! "Pete_UK" wrote: You can't do that with one of the standard Excel functions, but it is relatively easy to devise your own User Defined Function to read the color index of a cell. Bob Phillips show how he http://www.xldynamic.com/source/xld.ColourCounter.html and goes on to give many examples of how you can use such a function. Hope this helps. Pete On Feb 19, 10:44 pm, taurus99 wrote: Can you create a conditional statement that looks at the color of another cell? For example: I need column BN to look at column AX, if AX is RED, column BN needs to say FALSE. I have too many different values in AX, or I would use an actual value in my conditional statement for column BN. Thanks!- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional If Statements | Excel Discussion (Misc queries) | |||
Conditional If Statements | Excel Worksheet Functions | |||
Assigning a cell colors via IF-THEN statements | Excel Discussion (Misc queries) | |||
Conditional statements | Excel Worksheet Functions | |||
if statements with colors? | Excel Worksheet Functions |