Dynamic Conditional formatting

[Guest]

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,

 

[Don Guillett]

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

 

[Guest]

.... 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.

 

[Guest]

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!