Coloring Alternative Rows only if data is there

  • Thread starter Thread starter BetaDocuments
  • Start date Start date
B

BetaDocuments

Hi,

I have a spreadsheet with [ =MOD(ROW(),2)=1] conditional formatting
in it. I want to highlight this only if there data in there. I have
googled if but cannot find the method can anyone post the method or
provide me with link. It will be 2nd conditional formatting I think :l
 
=AND(COUNTA(1:1)>0,MOD(ROW(),2)=1)

--
__________________________________
HTH

Bob




Hi,
Click to expand...
I have a spreadsheet with   [ =MOD(ROW(),2)=1] conditional formatting
in it.  I want to highlight this only if there data in there.  I have
googled if but cannot find the method can anyone post the method or
provide me with link.  It will be 2nd conditional formatting I think :l- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Hi Bob,

This is not working properly. Do you want to try this in your excel
spreadsheet :(
 
I'm not Bob but it works for me in 2003.

If no data in any row, the rows are not color-banded as you requested.

Those that have data are alternating color-banding as you requested.

What "doesn't work" for you?

Or perhaps your original request was not what you meant?



Gord Dibben MS Excel MVP


=AND(COUNTA(1:1)>0,MOD(ROW(),2)=1)

--
__________________________________
HTH

Bob




Hi,
Click to expand...
I have a spreadsheet with   [ =MOD(ROW(),2)=1] conditional formatting
in it.  I want to highlight this only if there data in there.  I have
googled if but cannot find the method can anyone post the method or
provide me with link.  It will be 2nd conditional formatting I think :l- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Hi Bob,

This is not working properly. Do you want to try this in your excel
spreadsheet :(
Click to expand...
 
Then you need to explain in what way it is not working and more detail on
exactly what you need.

--
__________________________________
HTH

Bob

=AND(COUNTA(1:1)>0,MOD(ROW(),2)=1)

--
__________________________________
HTH

Bob




Hi,
Click to expand...
I have a spreadsheet with [ =MOD(ROW(),2)=1] conditional formatting
in it. I want to highlight this only if there data in there. I have
googled if but cannot find the method can anyone post the method or
provide me with link. It will be 2nd conditional formatting I think :l-
Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Hi Bob,

This is not working properly. Do you want to try this in your excel
spreadsheet :(
 
Back
Top