Conditional Formatting question...

[Dino]

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

 

[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.

 

[Bryan Hessey]

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.

 

[Sloth]

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.

 

[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]

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

Hopefully the OP will get it working too.

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