Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() sorry , I didn't explain it right. I want to highlight the 12 cells below the highlighted current date. these cells contain text, so I haven't got a date to conditinally format. "SteveW" wrote in message news:op.tmo46fioevjsnp@enigma03... 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. |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
That's the point.
You can't apply conditional formating to one cell to affect a different one. BUT you can use a different cell when setting up the conditional format for a cell So A1 = last week, b1 = this week, c2 = next week In B13 set up Conditional Format =IF(b1=this week,1,0) And set the format accordingly Steve On Thu, 25 Jan 2007 06:48:45 -0000, ned wrote: sorry , I didn't explain it right. I want to highlight the 12 cells below the highlighted current date. these cells contain text, so I haven't got a date to conditinally format. "SteveW" wrote in message news:op.tmo46fioevjsnp@enigma03... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel: Having more than 3 conditional formats would be helpful. | Excel Worksheet Functions | |||
how can i set more than three conditional formats to xl worksheet | Excel Worksheet Functions | |||
Why do conditional formats appear by themselves in Excel 2003? | Excel Discussion (Misc queries) | |||
how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
Conditional Formats in Excel | Excel Worksheet Functions |