Re: Conditional Format Using AND

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Coyote (Coyote_at_discussions.microsoft.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 10:19:04 -0800

Thanks For the reply Chip,

I understand that at least for now the 2004 condition will always be true
but I only want the color change to happen if "PREV" is in column A, hence my
problem. I was thinking maybe condition 1 could have an AND function to
first see if Column A is "PREV" and if true then test for the YEAR ansd set
the color.

"Chip Pearson" wrote:

> Since YEAR(TODAY()) = 2004 is always true (this year, at least),
> your second format condition will always be true and red format
> will be applied.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
> "Coyote" <Coyote@discussions.microsoft.com> wrote in message
> news:48132016-C147-4ED1-A9FD-FD7937E3C860@microsoft.com...
> > Please look at the following and help me with this conditional
> > format.
> > Column A: This column is either set to "CURR" or "PREV"
> >
> > I want Column B to be shaded "Red" if Column A is "PREV" and
> > the the Current
> > YEAR is 2004, "Blue" if Column A is "PREV" and the Currrent
> > YEAR is 2005.
> >
> > I tried using conditional formatting but I didn't have
> > something correct.
> > First condition: Formula is =$A1="PREV"
> > 2nd Condition: Formula is =(YEAR(TODAY()))=2004 Set format to
> > RED
> > 3rd Condition: Formula is =(YEAR(TODAY()))=2005 Set format to
> > BLUE
> >
> > Using the above conditions changed column B to "RED" regardless
> > of whether
> > or not Column A was "PREV"
> >
> > Thanks in Advance
> > Coyote
> >
> >
>
>
>

Relevant Pages

  • Re: [RFC PATCH 16/22 -v2] add get_monotonic_cycles
    ... and I just blew away all my marker code for something like this;-) ... const char *format, ...) ... struct task_struct *prev; ...
    (Linux-Kernel)
  • Re: stop script if dates are missing, edit help...
    ... he wanted the ability to enter the start date in 1/1/2005 format and ... right on column J, which is K, if any of those are missing to print out ... msg box and basically stop and say: make sure the dates in the range ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Counting blanks fields for a report
    ... >>report that have a Null status field. ... >>denominator in an expression. ... You want to format the expression as a ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: Closed for submissions
    ... I wouldn't otherwise buy in this format. ... One thing I use the phone (Nokia 9300) for is to go over the manuscript ... mark it with a string of asterisks and a color change, ...
    (rec.arts.sf.composition)