On Dec 4, 10:58*am, AdamV wrote:
I'm with Luke, that's the way round I would do it (although Don's code
should work).

As an aside / extra note, you should remember that you can enter into
multiple cells at once, so for example select B5:B9, type "R" and rather
than just enter, press Ctrl-Enter and it will put that entry in all
those cells. This should not be any more work than colouring a bunch of
cells, in my view.

Hope this helps
Adam



Luke M wrote:
I'm afraid XL is not built to handle formatting that way. However, it can do
the reverse, where you mark cells B5:B7 with the letter R, and it can then
color A5:A7 yellow. Would this work?

To do this, select cells A1:A200. Make sure A1 is the active cell (the cell
you would currently be editing). Goto Format - conditional formatting. Change
the first dropdown box to "formula is". In the next box, input:
=B1="R"
Click the format box, goto pattern, and choose a yellow fill. Ok out of the
format dialogue.

Ok out of the conditional format dialogue. You should be set now.- Hide quoted text -

- Show quoted text -

Thanks Don Luke and Adam for your help. I prefered Don's version
because that's what I was after.
I tried it and it work. It worked just the way I wanted. You're a
genius Don. I wish I increased my knowledge because I'm a total mess
expecially in VB.

With lots of appreciation - Silverman