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: 26
Default Conditional formatting based on conditions in other cells.

I have a form where I want the last entry in a column of numbers to be
underlined. Always entering from the top down, I want it so that if there is
one entry, it would be underlined, but if more entries are made, the
underline would always be under the last entry. The column is generally of
fixed length, although I do need to expand it on occasion.

How do I code this? Conditional formatting seems to be based only on the
conditions in that cell, not other cells. I assume Ill need to go to VBA.
Thanks in advance for any help.

 
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 Formatting based on 2 conditions Still learning@work Excel Discussion (Misc queries) 3 April 7th 09 11:11 PM
Conditional Formatting Based of Cells Based on Data Entry in anoth Jim Excel Discussion (Misc queries) 3 November 11th 08 11:52 PM
Conditional formatting Based on cell A text with conditions in Cell B Raicomm Excel Discussion (Misc queries) 0 January 21st 08 04:46 PM
Conditional Formatting Based on two cells in a row [email protected] Excel Worksheet Functions 2 May 18th 07 03:49 PM
Conditional Formatting of Rows Based On More Than 4 Conditions TRenick Excel Programming 3 April 6th 05 04:25 PM


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