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: 114
Default Highlight first blank cell in column

What code do I need to allow the first blank cell found in a range to be
highlighted.

Example

D1:D12 contains a value
D13 is the first blank cell in "D"

C5 is hightlighted

when code is run D13 is highlighted

Thank you if you can help with this.

 
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
Highlight Lowest value ignoring 0 or blank cell Marie Excel Discussion (Misc queries) 3 June 4th 08 11:04 PM
Highlight cells where the last charcter in the cell is a blank Pat[_4_] Excel Worksheet Functions 5 February 27th 08 01:21 PM
formula in excel that will highlight a cell that is left blank? Kimo Excel Worksheet Functions 4 July 21st 07 04:16 PM
Conditional Format to highlight blank cell DaveMoore Excel Worksheet Functions 4 June 23rd 05 10:10 AM
highlight non blank cells in column Annette[_4_] Excel Programming 6 December 20th 04 09:42 PM


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