I need to apply conditional formatting to some cells. It's quite easy using
the conditinal formatting function, but I need to use code.

Column A will be changing, and depending on if there is a value or not, I
need cells on that particular row to change color.
For example, if A1 has a value, and cells A3, A5, A7 are blank, they should
change color and a message should display. Once values are input in each cell
(A3,A5,A7), each cell should return to their original color.
Thanks in advance for your help.

Do it in Excel with the macro recorder on.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Myriam" wrote in message
...
I need to apply conditional formatting to some cells. It's quite easy
using
the conditinal formatting function, but I need to use code.

Column A will be changing, and depending on if there is a value or not, I
need cells on that particular row to change color.
For example, if A1 has a value, and cells A3, A5, A7 are blank, they
should
change color and a message should display. Once values are input in each
cell
(A3,A5,A7), each cell should return to their original color.
Thanks in advance for your help.

Thanks Bob.
I just realized I did not post the correct ranges.

If for example A7 has a value I need D7,F7,H7 to change colors until
those cells are entered a value
Then, let's say that there are no values from A8:A11, no color changes on
those rows.
A12 has a value, then, D12, F12 and H12 need to have a change of color...

I can't do it with macro recording...
Thanks.


"Bob Phillips" wrote:

Do it in Excel with the macro recorder on.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Myriam" wrote in message
...
I need to apply conditional formatting to some cells. It's quite easy
using
the conditinal formatting function, but I need to use code.

Column A will be changing, and depending on if there is a value or not, I
need cells on that particular row to change color.
For example, if A1 has a value, and cells A3, A5, A7 are blank, they
should
change color and a message should display. Once values are input in each
cell
(A3,A5,A7), each cell should return to their original color.
Thanks in advance for your help.