| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How Can i use the cell colors as logical tests?
i applied conditional formating to one cell. it changes the color when the
condition is right. can i compare this color with another cell color and put some formula that says "IF THE COLOR IN THE CELL S1 MATCHES THE COLOR OF CELL T1,RETURN THE VALUE THAT IS IN CELL A1"??? I guess u guys understand what i need......do u?? u must have....u people are better in excel. pl reply.thank u. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How Can i use the cell colors as logical tests?
Hi,
Excel doesn't provide any way to do that at worksheet level and in VBA the colorindex property doesn't work with cells coloured using CF. At worksheet level you can test the condition that caused the CF colour change instead of the colour itself. For example lets say you have a CF that turns A1 blue if it greater then 1. Testing if A1 is greater than 1 gets the same results as testing the CF colour. You can resort to VB code and here's how http://www.cpearson.com/excel/CFColors.htm Mike "kashof" wrote: i applied conditional formating to one cell. it changes the color when the condition is right. can i compare this color with another cell color and put some formula that says "IF THE COLOR IN THE CELL S1 MATCHES THE COLOR OF CELL T1,RETURN THE VALUE THAT IS IN CELL A1"??? I guess u guys understand what i need......do u?? u must have....u people are better in excel. pl reply.thank u. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How Can i use the cell colors as logical tests?
CF colored cells are difficult to work with because Excel does not recognize the
colorindex of a CF colored cell. You would be better off comparing the value(s) that the CF uses. For more information on CF Colors and some code see Chip Pearson's site. http://www.cpearson.com/excel/CFColors.htm Gord Dibben MS Excel MVP On Tue, 15 Jan 2008 05:09:00 -0800, kashof wrote: i applied conditional formating to one cell. it changes the color when the condition is right. can i compare this color with another cell color and put some formula that says "IF THE COLOR IN THE CELL S1 MATCHES THE COLOR OF CELL T1,RETURN THE VALUE THAT IS IN CELL A1"??? I guess u guys understand what i need......do u?? u must have....u people are better in excel. pl reply.thank u. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| logical test for an #N/A condition in a cell | Excel Discussion (Misc queries) | |||
| Logical test if cell uses formatting.. | Excel Worksheet Functions | |||
| logical test for each and every cell in range | Excel Discussion (Misc queries) | |||
| Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
| Average a group of tests for grade, some tests not taken by all. | Excel Discussion (Misc queries) | |||
Linear Mode
