Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 361

Conditional Formating

My data looks like this:

A B C D
0.00% 0.00% 100.00% 0.00%
5.92% 7.06% 13.98% 32.51%
4.05% 11.19% 17.65% 54.46%

Is there a way to entire row if any value in the row is greater than 50%
and/or Bold the Font of ColB if the cell value is less than 2%.

So in data above, rows 1 and 3 would be highlighted and B1 would be Bold Font.

Thank you in advance.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formating	kaci	Excel Worksheet Functions	7	January 16th 07 02:16 PM
conditional formating	Wilfried	New Users to Excel	3	December 29th 06 06:03 PM
Conditional Formating IS: Help With ANY VALUE	Paperback Writer	Excel Discussion (Misc queries)	6	December 1st 06 09:33 PM
Conditional Formating	Trying To Excel	Excel Worksheet Functions	3	December 9th 05 06:20 AM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM

All times are GMT +1. The time now is 06:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us