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.