How can I make cell A1 a "Y" or "N" depending upon cell A2's font color? Please help.

J

jdove78

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 (e-mail address removed)
Thanks again,
Jdove.
 
D

Dianne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting a cell's color based upon RGB values 6
How can I make a cell to flash? 6
Different Font Sizes In The Same Cell 4
Help Needed, May have bitten off more than I can chew 35
VB Code Highlight Rows Based on Color Index 8
I cannot get the color red fonts; red appears as black 1
locating specific cells marking location 0
How can I automatically color a cell based upon a condition being 4

Top