LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 54
Default Cond. Formatting, Mod(Row) and cell conditions

Is there any way to use the mod row function to shade alternative rows, based
on whether cells have any value in them.
I want to select a big range (eg A:G) and only shade alternative rows (A:G)
once data is place in cells.

the mod row function shades regardless if there is data in or not.
 
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
Cond. formatting, based on other cell values? GD Excel Discussion (Misc queries) 3 February 7th 09 07:26 PM
Cond. Formatting; If Cell B6 or B7 is blank I want Cell D12 to be Dr. Darrell Excel Discussion (Misc queries) 5 December 28th 08 08:54 PM
Two Separate Conditions for Cond. formatting [email protected] Excel Worksheet Functions 8 July 10th 07 06:30 PM
Cond Format - 7 conditions Sarah Excel Discussion (Misc queries) 6 April 28th 07 08:20 AM


All times are GMT +1. The time now is 04:02 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"