Conditional Formatting Help

[Justinian]

When I run CF, it only highlights the cell that contains my words. How do I get Excel to highlight the entire row?

 

[Justinian]

Yes, I did.

 

[bschwartz]

It is working on my spreadsheet. Can you post the formula you entered?

 

[Justinian]

Excel Workbook
	A	B	C	D	E
3	15202	SASCO	Executed	3,820.00	Unamended
4	16242	CHAMPION PAVING INC	Executed	63,778.00	Unamended
5	16244	GPS PAINTING AND WALLCOVERING INC	Executed	3,640.00	Unamended
6	16480	INDEPENDENT ROOFING CONSULTANTS	Executed	3,675.00	Unamended
7	18260	CHAMPION PAVING INC	Executed	63,778.00	Unamended
8	23137	KONE INC	REM	5,328.00	Unamended
9	23146	GREAT SCOTT TREE SERVICE INC	Executed	23,530.00	Unamended
10	23156	UNIQUE PLANT RENTALS	Executed	6,540.00	Unamended
11	23164	SOUTH SHORE BUILDING SERVICES INC	Executed	19,309.00	Unamended
12	23174	SERVICON SYSTEMS INC	Executed	384,143.64	Unamended
13	23179	AIR CONDITIONING CONTROL SYSTEMS INC	Executed	9,474.84	Unamended
14	23187	DEWEY SERVICES INCORPORATED	Executed	3,120.00	Unamended
15	23201	SOUTHWEST LANDSCAPE INC	Executed	52,800.00	Unamended
16	23613	COSTA MESA LOCK AND KEY	Executed	0.00	Unamended
17	23642	DANNY LETNER INC	Executed	9,900.00	Unamended
18	24657	THE GUERRA COMPANIES INC	Executed	1,500.00	Unamended
19	26103	JOHNSON CONTROLS INC / YORK INTERNATIONAL	Executed	10,512.00	Unamended
20	26503	HSG PROFESSIONAL WINDOW CLEANERS INC	Executed	4,500.00	Unamended
21	27068	CHEM PRO LABORATORY INC	Executed	1,140.00	Unamended
22	27235	HC INTEGRATED SYSTEMS INC	Executed	5,895.00	Unamended
23	32083	PACIFIC PLUMBING CO OF SANTA ANA	Ready for Execution	1,419.00	Unamended
24	36240	BUSHRA TSAI INC	Executed	2,400.00	Unamended
25	37974	C2 TECHNOLOGY PARTNERS INC	Executed	0.00	Unamended
26	39516	SMITHEMERY LABORATORIES	Executed	3,230.00	Unamended
27	39663	SOUTH COAST MECHANICAL INC	Ready for Review	0.00	Unamended
ACC

I did the whole table. I also ran into anther problem. People will be adding to this spreadsheet and I need the table to be dynamic so i don't have to keep reformatting it everytime someone adds something. How can that be done?

 

[Justinian]

Specific text containg REM.

 

[bschwartz]

Can you post the exact formula you entered?

Also for your second question, you should be able to allow for more data by simply expanding the range being formatted.

 

[Justinian]

It wasn't a formula. I used to preset of formatting cells containg specific text. Since I can only highlight one cell and not the row, I cannot expand the formula.

 

[bschwartz]

Ok, you need to use conditional formatting and the enter your own formula option.

Highlight the whole table. On the home tab, under format cells, go to the conditional formatting dropdown menu. Select manage rules. If there are any rules there highlight and delete them.

Select New Rule. On the top it says "Select a Rule Type."

Choose "Use a formula to determine which cells to format." In the formula bar below, enter this formula:

=$B2="reviewed"

Select "format" and choose the formatting you want. Select Ok and then Ok again.

 

[Justinian]

That is still only highlighting one cell and the table is not dynamic, so any new entries will not have this formatting.

 

[bschwartz]

Please POST here the formula you entered in the formula bar of conditional formatting.

P.S. When we get the first part working, we can expand the range to allow for new data.

 

[Justinian]

=C3="Ready for Review"