conditional formatting ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a calendar spreadsheet for some co-workers. I need a conditional format formula or a formula that will highlight from when a project starts to its launch date

Right now, I am using Conditional Formatting to highlight the start date and the Launch Date
Ex. Start Date is Jan1, Launch Date is Jun

Jan Feb Mar Apr May Ju
x---------------------------->

Thanks.
 
Sandy,

If you actually have x's in the month columns for start and end, this works.
Jan is in B1 and to the right. Select the cells below Jan-Dec, Format -
Conditional Formatting - Formula is:

=OR(SUMPRODUCT(--($B2:B2="x"))=1,B2="x")

The active (white) cell of your selection must be B2 for this formula. You
can paste it right from this post. Don't forget to put in a format, like a
pattern color for your highlight.z`
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Sandy said:
I am trying to create a calendar spreadsheet for some co-workers. I need
Click to expand...
a conditional format formula or a formula that will highlight from when a
project starts to its launch date.
 
This is what I have:

workbook with 3 sheets
1st-called 'Plan'--this is where my co-workers will input their new projects and update old ones. this sheet feeds the 1st four columns of my calendar sheet.
2nd-called 'Calendar'---I want this to be an automated sheet. so far, when anyone enters anything that would go in the 1st 4 columns, and then i have conditional formatting for the rest of the sheet (which is about 400 rows)

These are my conditional formattin formulas:
for the launch date: =COUNTIF(april,$C7)=1 (format cell blue)
for the start date: =COUNTIF(april,$D7)=1 (format cell d.blue)

I would like something (formula maybe) that would color the range between the start and the launch date.

Thanks for you help.
 
Sandy,

You'll have to be more specific about what's in your calendar sheet. Give
examples.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

sandy said:
This is what I have:

workbook with 3 sheets
1st-called 'Plan'--this is where my co-workers will input their new
Click to expand...
projects and update old ones. this sheet feeds the 1st four columns of my
calendar sheet.
2nd-called 'Calendar'---I want this to be an automated sheet. so far,
Click to expand...
when anyone enters anything that would go in the 1st 4 columns, and then i
have conditional formatting for the rest of the sheet (which is about 400
rows)
 
It might help if I could send you the file. Do you have an email address I could send this to

Thanks for your help
Sand

----- Earl Kiosterud wrote: ----

Sandy

You'll have to be more specific about what's in your calendar sheet. Giv
examples

--
Earl Kiosteru
mvpearl omitthisword at verizon period ne
------------------------------------------

sandy said:
This is what I have
1st-called 'Plan'--this is where my co-workers will input their ne
Click to expand...
projects and update old ones. this sheet feeds the 1st four columns of m
calendar sheet
2nd-called 'Calendar'---I want this to be an automated sheet. so far
Click to expand...
when anyone enters anything that would go in the 1st 4 columns, and then
have conditional formatting for the rest of the sheet (which is about 40
rows
 
Did you know that your email address is listed as (e-mail address removed)

----- Earl Kiosterud wrote: ----

Sandy

Yes
 
Back
Top