conditional formatting

[Waynest]

Hi

I want to set a conditional format as follows

If control-B < control-A then set forecolour of control-C to blue

I think I need to use the 'Expression is'facility, but dont know the syntax for the expressions.

Can someone give me an example? I am using Office XP.

Thanks
Wayne

 

[Petemush]

Try:

If yourControlA.Value < yourControlB.value Then yourControlC.ForeColor = 16711680

Cheers,

Pete

 

[captvideo33065]

Wayne,
You posted this:

I want to set a conditional format as follows

If control-B < control-A then set forecolour of control-C to blue

Did you ever get this to work? If yes, would you please explain it to me. Does the code go in an EventProcedure?

 

[Laois]

Wayne you are right, you need to use the Expression Is option and type the following.
[control-B]<[control-A]

Dermot