Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
CTO CTO is offline
external usenet poster
 
Posts: 1
Default conditional format whole row based on 2 rows

is it possible to format a whole row based on 2 cells with dates?
i would like to highlight the whole row if the second cell has already
gone beyond the date of the first cell.

for instance:
cell B1 has 2/1/07
cell B2 has 1/30/07
cell D1 has 2/3/07
cell D2 has 1/25/07

i want to be able to set a condition for the whole D column without
doing the tedious task of editing each row of D using Conditional
Formatting.

looking forward to everyone's reply.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 620
Default conditional format whole row based on 2 rows

CF/ Formula Is: =$D1$B1
--
David Biddulph

"CTO" wrote in message
oups.com...
is it possible to format a whole row based on 2 cells with dates?
i would like to highlight the whole row if the second cell has already
gone beyond the date of the first cell.

for instance:
cell B1 has 2/1/07
cell B2 has 1/30/07
cell D1 has 2/3/07
cell D2 has 1/25/07

i want to be able to set a condition for the whole D column without
doing the tedious task of editing each row of D using Conditional
Formatting.

looking forward to everyone's reply.



Reply
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 format based on other cells Tonto Excel Discussion (Misc queries) 3 October 14th 09 02:50 AM
Conditional Sum based on Bold Format Ron Excel Discussion (Misc queries) 3 February 8th 07 06:28 PM
Conditional Format based on Other Cells Fletch Excel Discussion (Misc queries) 2 October 10th 06 02:03 PM
Conditional Format based on range Dave Excel Discussion (Misc queries) 3 June 5th 06 06:15 AM
How do I set a Conditional Format for ROWs based on the value of . Wes T Excel Discussion (Misc queries) 3 December 29th 04 07:10 PM


All times are GMT +1. The time now is 07:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"