LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 18
Default Coloring Alternative Rows only if data is there

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional coloring of cells in VBA FOR DYNAMIC ROWS deepika :excel help[_2_] Excel Discussion (Misc queries) 5 January 30th 08 01:33 PM
VBA - Coloring Rows Instead of Cells J-D Excel Discussion (Misc queries) 4 May 4th 07 10:23 PM
Coloring rows of cells [email protected] Excel Discussion (Misc queries) 2 June 1st 06 02:24 PM
Coloring rows in excel Kjetil Excel Worksheet Functions 5 December 10th 05 02:37 PM
coloring in rows koba Excel Discussion (Misc queries) 9 November 10th 05 05:57 AM


All times are GMT +1. The time now is 07:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"