colour in cell

[David]

Can the replace command be used for colours on a cell? I
would like to replace all the cells with a particular
color with text.
Regards,
David

 

[Bob Phillips]

David,

Have you tried putting the ranges in brackets, e.g.

(A1:A10, B3:F3)

as you values

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

Sorry, answered wrong question.

The answer to this question is no, but you could use VBA to do it.


Bob

 

[Earl Kiosterud]

This one's been coming up more and more. Let me say this to all. Don't use
colors as a way of inputting things into a worksheet. Colors should be for
display (output) only. There aren't ready ways to examine the colors that
have been set manually.

Instead, put values into cells -- stuff we can read, and formulas and other
things can examine. Then you can use things like Conditional Formatting to
cause colors to appear.