Prev: Pivot Table Page Field value from cell in another worksheet
Next: How to skip the enable update confirmation?
From: L. Howard Kittle on 24 May 2010 02:25
You are welcome, thanks for the feedback.

Howard

"Missile" <Missile(a)discussions.microsoft.com> wrote in message
news:110BDDF2-E7F3-453F-BE16-90806A8A9B57(a)microsoft.com...
> After some help with Conditional Formatting.
> As an example I have the following data in cells B1 & B2;
> Cell B1 "Project 1 - Testing"
> Cell B2 "Project 2 - Not Issued"
> I want the cells containing the words "Not Issued" to be shaded (Green).
> In
> this example that would be "B2".
> Also I would like the same shading applied to cells A2, C2 to H2.
>
>
> Thanks


From: FSt1 on 24 May 2010 03:09
hi
and you are right. i didn't read close enough or read too quickly or
something.
thanks for the correction.

regards
FSt1

"L. Howard Kittle" wrote:

> Hi FSt1,
>
> Just to note, the OP says the cells will contain something like "Project 1 -
> Not Issued". So =$B2="Not Issued" will not work if other characters are in
> the cell.
>
> =COUNTIF(B1,"*Not Issued*")>0 looks for the occurrence of Not Issued among
> all the characters in the cell.
>
> Regards,
> Howard
>
> "FSt1" <FSt1(a)discussions.microsoft.com> wrote in message
> news:49EC047B-58CE-4336-9D54-BA298586DDC7(a)microsoft.com...
> > hi
> > while holding the Ctrl key down...with the mouse...select A2,C2 and H2.
> > on the menu bar>format>conditional format
> > Formula is.......=$B2="Not Issued"......pick your shade of green.
> > ok out.
> > the key is the dollar sign($). this points all selected cells in the row
> > at
> > column B but not the row so that you can copy A2:H2 and copy down as far
> > as
> > needed.
> >
> > regards
> > FSt1
> >
> > "Missile" wrote:
> >
> >> After some help with Conditional Formatting.
> >> As an example I have the following data in cells B1 & B2;
> >> Cell B1 "Project 1 - Testing"
> >> Cell B2 "Project 2 - Not Issued"
> >> I want the cells containing the words "Not Issued" to be shaded (Green).
> >> In
> >> this example that would be "B2".
> >> Also I would like the same shading applied to cells A2, C2 to H2.
> >>
> >>
> >> Thanks
>
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Pivot Table Page Field value from cell in another worksheet
Next: How to skip the enable update confirmation?