I have an AI list in Excel. I am using Columns A through J. Column E
contains the status of the AI. When this cell = Closed I would like Columns
A:J to automatically fill with gray. I also have due date in column K. When
this date is earlier than current date I would like it to turn red.

Can someone help me with this? I am not a programmer but understand a
little about macros.

Thanks in advance.

You should be able to do what you want to accomplish with just Conditional
Formatting, and not need macros............give it a try and come back if you
need more help.

Vaya con Dios,
Chuck, CABGx3



"C" wrote:

> I have an AI list in Excel. I am using Columns A through J. Column E
> contains the status of the AI. When this cell = Closed I would like Columns
> A:J to automatically fill with gray. I also have due date in column K. When
> this date is earlier than current date I would like it to turn red.
>
> Can someone help me with this? I am not a programmer but understand a
> little about macros.
>
> Thanks in advance.

How do I get the complete row to fill A1:J1 if E = Closed?????

"CLR" wrote:

> You should be able to do what you want to accomplish with just Conditional
> Formatting, and not need macros............give it a try and come back if you
> need more help.
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "C" wrote:
>
> > I have an AI list in Excel. I am using Columns A through J. Column E
> > contains the status of the AI. When this cell = Closed I would like Columns
> > A:J to automatically fill with gray. I also have due date in column K. When
> > this date is earlier than current date I would like it to turn red.
> >
> > Can someone help me with this? I am not a programmer but understand a
> > little about macros.
> >
> > Thanks in advance.

Use an absolute reference. Select A1:J1, choose "Formula Is" from the drop
down and use this formula in the field next to the drop down...

=$E1="Closed"

--
Rick (MVP - Excel)


"C" <(E-Mail Removed)> wrote in message
news:8B6B0A72-9D0B-4A57-9395-(E-Mail Removed)...
> How do I get the complete row to fill A1:J1 if E = Closed?????
>
> "CLR" wrote:
>
>> You should be able to do what you want to accomplish with just
>> Conditional
>> Formatting, and not need macros............give it a try and come back if
>> you
>> need more help.
>>
>> Vaya con Dios,
>> Chuck, CABGx3
>>
>>
>>
>> "C" wrote:
>>
>> > I have an AI list in Excel. I am using Columns A through J. Column E
>> > contains the status of the AI. When this cell = Closed I would like
>> > Columns
>> > A:J to automatically fill with gray. I also have due date in column K.
>> > When
>> > this date is earlier than current date I would like it to turn red.
>> >
>> > Can someone help me with this? I am not a programmer but understand a
>> > little about macros.
>> >
>> > Thanks in advance.

On 16 Iul, 17:03, C <C...@discussions.microsoft.com> wrote:
> How do I get the complete row to fill A1:J1 if E = Closed?????

A little answer :

Sub ColorGray()

If Range("E1").Value = "Closed" Then
Columns("A:J").Select
With Selection.Interior
.ColorIndex = 15
End With
End If

End Sub

> When this cell = Closed ..... ....

Which one ? I put in in cell E1 , make adjustments according
with your needs