| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I make cell A1 a "Y" or "N" depending upon cell A2's font color? Please help.
How can I make cell A1 a "Y" or "N" depending upon cell A2's font color? Please help.
If anyone can answer this question I'll be extremely grateful. It doesn't matter to me how it is accomplished... macros VB or no VB. Please feel free to email me at Thanks again, Jdove. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I make cell A1 a "Y" or "N" depending upon cell A2's font color? Please help.
How about
Sub CheckColour() Select Case ActiveSheet.Range("A2").Font.Color Case vbRed ActiveSheet.Range("A1").Value = "Y" Case Else ActiveSheet.Range("A1").Value = "N" End Select End Sub -- Dianne In , typed: How can I make cell A1 a "Y" or "N" depending upon cell A2's font color? Please help. If anyone can answer this question I'll be extremely grateful. It doesn't matter to me how it is accomplished... macros VB or no VB. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup and bring the "font color" of the cell across? | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) | |||
| Any IF(A2=font color=red", "1", "0") in excel? Or a way to do it? | Excel Discussion (Misc queries) | |||
Hybrid Mode
