Another Custom Format Cell question

eliW · May 1st, 2002, 11:41 PM

Hello all,
In my following questions I am not looking for VBA or Conditional Formatting solutions!
(Qroozn suggested again conditional formatting but its no good as I need about 6 conditions.)

1) Is there any way to custom format cell by its TEXT content, like([red][="eli"]0)?
2) Is there any way to color the entire cell when condition is met, not just the fonts ?
3) The examples in the help to Custom Format are quite poor in Excel97, can anybody recommend on a tutorial?
Thanks in advance,
Eli

[ This Message was edited by: eliW on 2002-05-01 23:01 ]

Qroozn · May 1st, 2002, 11:46 PM

I'll stick to the conditional formatting approach.

(what is wrong with it?)

eliW · May 2nd, 2002, 10:58 AM

please help

[ This Message was edited by: eliW on 2002-05-11 10:29 ]

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

May 1st, 2002, 11:41 PM	#1
eliW Board Regular Join Date: Mar 2002 Posts: 1,805	Hello all, In my following questions I am not looking for VBA or Conditional Formatting solutions! (Qroozn suggested again conditional formatting but its no good as I need about 6 conditions.) 1) Is there any way to custom format cell by its TEXT content, like([red][="eli"]0)? 2) Is there any way to color the entire cell when condition is met, not just the fonts ? 3) The examples in the help to Custom Format are quite poor in Excel97, can anybody recommend on a tutorial? Thanks in advance, Eli [ This Message was edited by: eliW on 2002-05-01 23:01 ]

May 1st, 2002, 11:46 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	I'll stick to the conditional formatting approach. (what is wrong with it?)

May 2nd, 2002, 10:58 AM	#3
eliW Board Regular Join Date: Mar 2002 Posts: 1,805	please help [ This Message was edited by: eliW on 2002-05-11 10:29 ]