I am able to format every other row with conditional formatting, but I need
to take it further. The amount of rows update daily and I only want to format
if there is data in that row. (It can look at the first column for a number >
1)

So lets say my data is from A5 - N145 today, but tomorrow it may be A5 –
N205 or A5 – N20

I have no problem putting this in a macro where it will first clear all of
the formatting and then reformat accordingly.

Thanks,

formula is>
=if $A5>0
format as desired>copy format

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"DS" <(E-Mail Removed)> wrote in message
news:82E0EDE7-AD04-45C4-8546-(E-Mail Removed)...
>
> I am able to format every other row with conditional formatting, but I
> need
> to take it further. The amount of rows update daily and I only want to
> format
> if there is data in that row. (It can look at the first column for a
> number >
> 1)
>
> So lets say my data is from A5 - N145 today, but tomorrow it may be A5 –
> N205 or A5 – N20
>
> I have no problem putting this in a macro where it will first clear all of
> the formatting and then reformat accordingly.
>
> Thanks,
>

.... but this is still not dynamic. Unless I am doing it wrong (probably am)
This will highlight every row that is >0
or
every other row that is selected if A5>0 when I add:
mod(row(),2)=1 to the second condition

I am looking for every other row to be highlighted until the end of the data.

Hope I am clear enough.

Thank you.




"Don Guillett" wrote:

> formula is>
> =if $A5>0
> format as desired>copy format
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "DS" <(E-Mail Removed)> wrote in message
> news:82E0EDE7-AD04-45C4-8546-(E-Mail Removed)...
> >
> > I am able to format every other row with conditional formatting, but I
> > need
> > to take it further. The amount of rows update daily and I only want to
> > format
> > if there is data in that row. (It can look at the first column for a
> > number >
> > 1)
> >
> > So lets say my data is from A5 - N145 today, but tomorrow it may be A5 –
> > N205 or A5 – N20
> >
> > I have no problem putting this in a macro where it will first clear all of
> > the formatting and then reformat accordingly.
> >
> > Thanks,
> >
>
>

NEVER MIND!

It is good.

Yes, the way I have it will format the row even if there is no value, but it
willn ot print it. (Not sure why, because I thought when I simply formatted
the every other row manually, it would print just a bunch of shaded blank
rows...?)

Anyway, I think we have it.

THANK YOU!

"DS" wrote:

> ... but this is still not dynamic. Unless I am doing it wrong (probably am)
> This will highlight every row that is >0
> or
> every other row that is selected if A5>0 when I add:
> mod(row(),2)=1 to the second condition
>
> I am looking for every other row to be highlighted until the end of the data.
>
> Hope I am clear enough.
>
> Thank you.
>
>
>
>
> "Don Guillett" wrote:
>
> > formula is>
> > =if $A5>0
> > format as desired>copy format
> >
> > --
> > Don Guillett
> > Microsoft MVP Excel
> > SalesAid Software
> > (E-Mail Removed)
> > "DS" <(E-Mail Removed)> wrote in message
> > news:82E0EDE7-AD04-45C4-8546-(E-Mail Removed)...
> > >
> > > I am able to format every other row with conditional formatting, but I
> > > need
> > > to take it further. The amount of rows update daily and I only want to
> > > format
> > > if there is data in that row. (It can look at the first column for a
> > > number >
> > > 1)
> > >
> > > So lets say my data is from A5 - N145 today, but tomorrow it may be A5 –
> > > N205 or A5 – N20
> > >
> > > I have no problem putting this in a macro where it will first clear all of
> > > the formatting and then reformat accordingly.
> > >
> > > Thanks,
> > >
> >
> >