Conditional Formatting question...

Is there a way to have Excel look in a particular cell, and if the value in
the cell meets a requirement (such as Complete), then shade the entire row a
different color? I can use conditional formatting to get the one cell
shaded, but I can't get the rest of the row to be shaded.

Thanks!
Dino

Try using an absolute reference in your Conditional Format formula. For
example, if the cell that contains the value "complete" is A1, then refer to
it as $A$1.

"Dino" wrote:

> Is there a way to have Excel look in a particular cell, and if the value in
> the cell meets a requirement (such as Complete), then shade the entire row a
> different color? I can use conditional formatting to get the one cell
> shaded, but I can't get the rest of the row to be shaded.
>
> Thanks!
> Dino
>
>
>

Hi Elkar, Dino,

I usually have trouble conditionally shading a row (or multiple cells) unless I re-edit the stated formula and remove added quotes, thus, selecting a number of cells (across a row etc) and setting the conditional format to

Formula
=$A$2="Complete"

I then have to re-edit that formula which shows as ="$A$2="Complete""
back to =$A$2="Complete"

The alternative seems to be that you set the condition to Formula, and then use the 'Conditional Formating - Value' dropdown, select the condition cell, then type in ="Complete"
and press Enter.


Obviously something I am not doing correctly, or a bug in the setting, but it does work after removing the un-required quotes.

Originally Posted by Elkar

Try using an absolute reference in your Conditional Format formula. For
example, if the cell that contains the value "complete" is A1, then refer to
it as $A$1.

"Dino" wrote:

> Is there a way to have Excel look in a particular cell, and if the value in
> the cell meets a requirement (such as Complete), then shade the entire row a
> different color? I can use conditional formatting to get the one cell
> shaded, but I can't get the rest of the row to be shaded.
>
> Thanks!
> Dino
>
>
>

Select the rows you want highlighted (in my example use highlight row 1) and
goto format->conditional formatting. select "Formula is" and use something
like
=$A1=1
as your formula. Include both equal signs. This will highlight the whole
row if the cell in column A is equal to 1. This should at least point you in
the right direction.

"Dino" wrote:

> Is there a way to have Excel look in a particular cell, and if the value in
> the cell meets a requirement (such as Complete), then shade the entire row a
> different color? I can use conditional formatting to get the one cell
> shaded, but I can't get the rest of the row to be shaded.
>
> Thanks!
> Dino
>
>
>

I believe you only have to do that if you forget the first "=". At least
that is the only time I ever have to do delete the quotes.

"Bryan Hessey" wrote:

>
> Hi Elkar, Dino,
>
> I usually have trouble conditionally shading a row (or multiple cells)
> unless I re-edit the stated formula and remove added quotes, thus,
> selecting a number of cells (across a row etc) and setting the
> conditional format to
>
> Formula
> =$A$2="Complete"
>
> I then have to re-edit that formula which shows as ="$A$2="Complete""
> back to =$A$2="Complete"
>
> The alternative seems to be that you set the condition to Formula, and
> then use the 'Conditional Formating - Value' dropdown, select the
> condition cell, then type in ="Complete"
> and press Enter.
>
>
> Obviously something I am not doing correctly, or a bug in the setting,
> but it does work after removing the un-required quotes.
>
>
> Elkar Wrote:
> > Try using an absolute reference in your Conditional Format formula.
> > For
> > example, if the cell that contains the value "complete" is A1, then
> > refer to
> > it as $A$1.
> >
> > "Dino" wrote:
> >
> > > Is there a way to have Excel look in a particular cell, and if the
> > value in
> > > the cell meets a requirement (such as Complete), then shade the
> > entire row a
> > > different color? I can use conditional formatting to get the one
> > cell
> > > shaded, but I can't get the rest of the row to be shaded.
> > >
> > > Thanks!
> > > Dino
> > >
> > >
> > >
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=486382
>
>

Thanks Sloth, that looks correct, although I thought I had typed =$A$2="Complete" as per my post.

Hopefully the OP will get it working too.


[QUOTE=Sloth]I believe you only have to do that if you forget the first "=". At least
that is the only time I ever have to do delete the quotes.

"Bryan Hessey" wrote:
[color=blue]
>
> Hi Elkar, Dino,
>
> I usually have trouble conditionally shading a row (or multiple cells)
> unless I re-edit the stated formula and remove added quotes, thus,
> selecting a number of cells (across a row etc) and setting the
> conditional format to
>
> Formula
> =$A$2="Complete"
>
> I then have to re-edit that formula which shows as ="$A$2="Complete""
> back to =$A$2="Complete"
>
> The alternative seems to be that you set the condition to Formula, and
> then use the 'Conditional Formating - Value' dropdown, select the
> condition cell, then type in ="Complete"
> and press Enter.

>
> Obviously something I am not doing correctly, or a bug in the setting,
> but it does work after removing the un-required quotes.