Format Row based on text value in cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barnabas - 25 Jun 2004 20:00 GMT

I want to format a row based on the value of one of the
cells in the row. Basically, I want to set the color of
the row to green if a particular cell in the row is
COMPLETE and red otherwise. How can I do this?

Thanks,
B.

Reply to this Message

Eric - 25 Jun 2004 22:28 GMT

Search for "Conditional Formatting" in Excel help.

Also, you can find help for Conditional Formatting on
Chip's website, http://www.cpearson.com/excel.htm

Hope that helps!

Eric

Reply to this Message

Max - 26 Jun 2004 05:47 GMT

Maybe you'll like to experiment with this as well ..

Assume the target row is row2,
the particular cell in the row is B2,
and the spec "COMPLETE"
means B2 contains the word "COMPLETE"

Select row2

Format the fill color for row2 as Red

Click Format > Conditional Formatting (with row2 still selected)

Make the settings under Condition 1:

Formula Is | =TRIM($B$2)="Complete"
Click Format button > Patterns tab > Light green > Ok

Click OK at the main dialog

Signature

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

> I want to format a row based on the value of one of the
> cells in the row. Basically, I want to set the color of
[quoted text clipped - 3 lines]
> Thanks,
> B.

Reply to this Message

Max - 27 Jun 2004 01:43 GMT

Just to cover a possible? lateral interpretation ..

If the spec "COMPLETE" means B2 contains "something"
(rather than the word "COMPLETE")

the lines:

> Make the settings under Condition 1:
> Formula Is | =TRIM($B$2)="Complete"

should read as:

> Make the settings under Condition 1:
> Formula Is | =NOT(ISBLANK($B$2))

Signature

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

Reply to this Message