LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 177
Default Conditional Formatting -- Apply to Row if Cell Value does not Matc

In Column A, How to I insert lines for whenever the values change for the
entire row A:AS.

Pears
Pears
Pears
Apples
Apples
Oranges
Oranges

I tried conditional formatting, but I only figured out how to use it for a
specific cell, not a row, and only for specific cells -- not relative to
changes to the cell above...

thanks very much...


 
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
Apply Conditional Formatting If Data in More Than 1 Cell Matches Maureen Excel Discussion (Misc queries) 5 March 5th 09 03:35 PM
Apply conditional formatting to individual cell Excel 2007 James D Excel Worksheet Functions 3 June 3rd 07 09:59 PM
How do I apply conditional formatting? Ken321 Excel Worksheet Functions 1 October 10th 06 02:36 PM
apply conditional formatting to negative cell values dona Excel Discussion (Misc queries) 2 March 10th 06 12:04 PM
apply conditional formatting Colby Excel Programming 2 August 21st 04 02:54 AM


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