Adding colors to a condition

Fred13x · Apr 24th, 2002, 07:38 AM

Is it possible to add a color to condition. If I use "IF>4" can I get it to add red to the cell? Thanks.

Nobby · Apr 24th, 2002, 07:44 AM

Yes, use Conditional Formatting.

Go to Format/Conditional Formatting and select "Formula is". The rest is self-explanatory.

Nobby

lenze · Apr 24th, 2002, 07:45 AM

Use condtional formatting. A search of the site for conditional formatting will show you many examples.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 07:38 AM	#1
Fred13x New Member Join Date: Apr 2002 Posts: 4	Is it possible to add a color to condition. If I use "IF>4" can I get it to add red to the cell? Thanks.

Apr 24th, 2002, 07:44 AM	#2
Nobby Board Regular Join Date: Feb 2002 Location: United Kingdom Posts: 68	Yes, use Conditional Formatting. Go to Format/Conditional Formatting and select "Formula is". The rest is self-explanatory. Nobby

Apr 24th, 2002, 07:45 AM	#3
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Use condtional formatting. A search of the site for conditional formatting will show you many examples.