Prev: Pivot Table Page Field value from cell in another worksheet
Next: How to skip the enable update confirmation?
From: Missile on 23 May 2010 22:42
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 00:44
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
From: L. Howard Kittle on 24 May 2010 00:54
Select the cells you want to check for Not Issued. Say B1:B5

In Format > Conditional formatting > Formula Is > =COUNTIF(B1,"*Not
Issued*")>0 > Format > Patterns > click on green > OK out.

So now if you select B5 and note the conditional formatting in it, you will
see the formula refers to B5 in that cell.

Is not case sentive.

Here is the formula again if perhaps the >'s got you confused in my
instructions.

=COUNTIF(B1,"*Not Issued*")>0

HTH
Regards,
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: L. Howard Kittle on 24 May 2010 01:06
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


From: Missile on 24 May 2010 01:48
Excellent, thanks for that, modified it slightly and it works perfectly.
Added $ to the B1, eg. =COUNTIF($B1,"*Not Issued*")>0


"L. Howard Kittle" wrote:

> Select the cells you want to check for Not Issued. Say B1:B5
>
> In Format > Conditional formatting > Formula Is > =COUNTIF(B1,"*Not
> Issued*")>0 > Format > Patterns > click on green > OK out.
>
> So now if you select B5 and note the conditional formatting in it, you will
> see the formula refers to B5 in that cell.
>
> Is not case sentive.
>
> Here is the formula again if perhaps the >'s got you confused in my
> instructions.
>
> =COUNTIF(B1,"*Not Issued*")>0
>
> HTH
> Regards,
> 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
>
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: Pivot Table Page Field value from cell in another worksheet
Next: How to skip the enable update confirmation?