View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Terry Pinnell[_4_] Terry Pinnell[_4_] is offline
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