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: 192
Default Conditional row height?

In Excel 2000 I read "For Conditional Formatting you can set Font
Style, Underline, Color, and Strikethrough." Is there any way to
adjust Row Height please?

For example, Col B contains dates sorted in descending order. The top
one for example was entered as '30/10/16' and formatted in Excel 2000
as

All row heights are currently 12.75. I would like dates later than
today's date to be 16.0 in height. So in this example (as at today,
8th April), the top five would be distinctly higher than the bottom
three. I'd prefer that to changing colour, or style, but only if it's
simple to implement!

2016 20161030 Return from Spain
2016 20161025 To St Feliu
2016 20160605 Sun 5 Jun EGWAS Walk
2016 20160526 26 May J to Iceland, 1 week
2016 20160415 Fri 18 Mar Brian, Jean, Joy, Tony
2016 20160407 Thu 7th Apr Return
2016 20160401 Fri 1st Apr Marseilles
2016 20160328 Fri 28th Good Friday

--
Terry, East Grinstead, UK
 
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
Row Height stopped growing and Auot-Fit Row Height does not work PSULionRP Excel Discussion (Misc queries) 0 May 19th 09 07:59 PM
How do I use conditional formatting to set text height and indent. Melody New Users to Excel 1 December 31st 08 04:03 PM
Conditional Row Height dhstein Excel Discussion (Misc queries) 3 November 3rd 08 11:29 PM
Resizing row height to dynamically fit height of text box Jon Excel Discussion (Misc queries) 1 August 8th 05 01:37 PM
How to edit row height with conditional formatting? CDAK Excel Discussion (Misc queries) 4 June 12th 05 06:41 PM


All times are GMT +1. The time now is 05:01 PM.

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"