View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default Conditional Formats

Apply a conditional format to that cell, the one 12 below

Refer to the original set of dates.

Steve

On Thu, 25 Jan 2007 05:59:40 -0000, ned wrote:

Hi
I have a row of dates, one week apart and I use the conditional format to
highlight the current week. I would like to highlight the column 12 cells
below the current date which contain text . I tried numerous things
,but my
knowledge is limited.
Is it possible to do?
Thankyou.