Format cells

Mar 11th, 2002, 12:05 PM

I am wondering can a IF formula format the cells?
eg. I am trying to change the text colour in certain cells

Mark W. · Mar 11th, 2002, 12:06 PM

Use the Format | Conditional Formatting... menu command.

Mar 11th, 2002, 12:12 PM

So what should I type in if I need to change the format of column2 by checking column3
eg
if(cell in column3="", change cell in column2 to white text, else do nothing)
Thanks in advance

Mar 11th, 2002, 12:14 PM

Oh I got it
Thanks

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

Mar 11th, 2002, 12:05 PM	#1
Guest Posts: n/a	I am wondering can a IF formula format the cells? eg. I am trying to change the text colour in certain cells

Mar 11th, 2002, 12:06 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Use the Format \| Conditional Formatting... menu command.

Mar 11th, 2002, 12:12 PM	#3
Guest Posts: n/a	So what should I type in if I need to change the format of column2 by checking column3 eg if(cell in column3="", change cell in column2 to white text, else do nothing) Thanks in advance

Mar 11th, 2002, 12:14 PM	#4
Guest Posts: n/a	Oh I got it Thanks