| 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. |
| 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) | |||
Threaded Mode
