About Us

Jim

Excel Users,

Thanks for the help. I would like to apply a conditional format to A1 if A2
meets a criteria.

For example if A2 is 100%, I would like A1 to become bold. I can't seem to
figure out this formula. Can you help?

Thanks
Jim

Mike H

Jim,

The CF formula is

=A2=1

and then select Bold font

Mike

"Jim" wrote:

Excel Users,

Thanks for the help. I would like to apply a conditional format to A1 if A2
meets a criteria.

For example if A2 is 100%, I would like A1 to become bold. I can't seem to
figure out this formula. Can you help?

Thanks
Jim

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formating	kaci	Excel Worksheet Functions	7	January 16th 07 02:16 PM
conditional formating #N/A	Dave	Excel Worksheet Functions	2	January 12th 07 03:07 PM
Conditional Formating	Dan	Excel Worksheet Functions	0	March 26th 06 11:45 PM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM
conditional formating	Jed	Excel Discussion (Misc queries)	3	June 14th 05 05:11 PM

Menu

About Us