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.


Sloth Wrote:[color=blue]
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.


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