Posted to microsoft.public.excel.misc

external usenet poster

Posts: 5

Conditional formatting problem

I'm trying to use Conditional Formatting to highlight a row using an if
formula.
eg
if a2=y then make row bold.

I've followed the various tutorials online and selected the range I wish to
apply the CF to, selected new rule, used the formula option, entered =$a2=y
in the formula box and changed the formatting to bold, but nada, the
formatting doesn't change at all.

Anyone got any ideas?

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 Formatting problem	James A	Excel Discussion (Misc queries)	3	January 1st 07 07:50 PM
Conditional Formatting problem	Neo1	Excel Worksheet Functions	3	March 7th 06 12:18 PM
Conditional Formatting Problem	TxAg	Excel Discussion (Misc queries)	2	October 3rd 05 09:51 PM
Conditional formatting problem	Bryan	Excel Discussion (Misc queries)	3	July 16th 05 01:29 PM
Conditional Formatting Problem	msimpy22	Excel Discussion (Misc queries)	1	March 1st 05 04:17 AM

All times are GMT +1. The time now is 09:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us