conditional formatting

[dolingercha]

I'd like to know how to change the color or an entire row,
if the word yes appears in column B (yes, in column B
reflects a new client for 3 consecutive months).

Thanks for any information

 

[JulieD]

Hi

select the worksheet (either the whole lot or the active area)
choose
format / conditional formatting
set it as:
formula is
then type
=$B1="yes"
set the format as desired
click OK

Cheers
JulieD

 

[Gord Dibben]

Select a bunch of row headers or just row 1.

Format>Conditional Formatting.

Formula is: =$B1="yes"

Select a color from "Format" and OK your way out.

If you selected just row 1, you can use the Format Painter to copy formatting
to other rows.

Gord Dibben Excel MVP

 

[dolingercha]

I've tried this formula and it does not select only the
ones in column B that have the word yes, it picks some
with and others without. I typed exactly as you've typed
and then selected the color blue.

 

[dolingercha]

Thanks, this worked great!!!

-----Original Message-----
Select a bunch of row headers or just row 1.

Format>Conditional Formatting.

Formula is: =$B1="yes"

Select a color from "Format" and OK your way out.

If you selected just row 1, you can use the Format Painter to copy formatting
to other rows.

Gord Dibben Excel MVP



.

 

[JulieD]

Hi

i'm glad that Gord's solution worked, but i'm still confused as to why you
had problems with my solution as it works when i re-test it .. .i'm using
excel 2003 ... what version do you have?

Cheers
JulieD

 

[David McRitchie]

Hi Julie,
Nothing to do with the version. The formula is based on the active
cell. He may not have had the active cell in row 1 when the formula
was entered. The range may have been chosen with say row 10 at
the top, then the active cell would not be in the upperleft corner of the
selected range. Until it is clearly understood that the formulas
generated for each cell in the conditional formatting are based on
the active cell -- Conditional Formatting will seem mysterious in
that it appears to work sometimes and sometimes is coloring a
different set of cells.
Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Conditional Formatting formulas are based on the active cell when entered.
Conditional Formatting formulas are based on the active cell when entered.
--

 

[JulieD]

Hi David

took me a long time to get a situation where it failed - but i understand it
now .. .i'm amazed that i've never encountered the problem before.

thanks for the explaination.

Cheers
JulieD

Hi Julie,
Nothing to do with the version. The formula is based on the active
cell. He may not have had the active cell in row 1 when the formula
was entered. The range may have been chosen with say row 10 at
the top, then the active cell would not be in the upperleft corner of the
selected range. Until it is clearly understood that the formulas
generated for each cell in the conditional formatting are based on
the active cell -- Conditional Formatting will seem mysterious in
that it appears to work sometimes and sometimes is coloring a
different set of cells.
Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Conditional Formatting formulas are based on the active cell when entered.
Conditional Formatting formulas are based on the active cell when entered.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Hi

i'm glad that Gord's solution worked, but i'm still confused as to why you
had problems with my solution as it works when i re-test it .. .i'm using
excel 2003 ... what version do you have?

Cheers
JulieD