Posted to microsoft.public.excel.programming

Jeff

external usenet poster

Posts: 921

IF Statements

Does anyone know how to use an IF statement to change the color of a cell??

An easy example: =IF(A1<=5,1,0). Can I change the value_if_true or
value_if_false to change the color of the cell?

Could probably read: =IF(A1<=5,1,"cell=green")

Thanks.

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
IF statements	dannyboy8	Excel Worksheet Functions	1	May 14th 08 05:10 PM
If statements	Conan Kelly	Excel Discussion (Misc queries)	1	January 31st 08 08:22 PM
IF Statements (Mutliple Statements)	Deezel	Excel Worksheet Functions	3	October 19th 06 06:13 AM
if statements	qwerty_2006	Excel Worksheet Functions	3	March 12th 06 08:09 AM
IF and OR statements	Loraloo	Excel Discussion (Misc queries)	3	March 4th 06 11:42 PM

All times are GMT +1. The time now is 04:22 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us