Hi,
If I have a cell (b1) where the text colour is say red, I would like a formula that puts a "R" in (c1).
I also have text that is green, blue.
I have tried @if function using b1=Selection.Font.ColorIndex = 3, but this doesn't work any ideas
ray:
If I have a cell (b1) where the text colour is say red, I would like a formula that puts a "R" in (c1).
I also have text that is green, blue.
I have tried @if function using b1=Selection.Font.ColorIndex = 3, but this doesn't work any ideas
ray: