Change one cell's format based on value of another without cond fm
 

Using Excel 2003 with XP.

Cell J contains a value
Cell I contains a date

I want to have the date in "I" appear in bold, red font if the value in J
is < 3.
How can I do this without conditional formatting (already used up my 3
conditions)?

This needs to apply to all rows in the sheet. If there's a way to make it
happen as the information is entered (J is automatically populated by
information entered in G/H), that would be great.

I realize it will require a macro, I just can't figure out how to do it.

Thanks!
--
JoAnn

Change one cell's format based on value of another without cond fm
 

Hi JoAnn,
If you've already used your 3 conditions, you'd need to do it with VBA.
Regards, Dave.

Change one cell's format based on value of another without con
 

Oops, sorry,
I now see that you'd already reached that conclusion.
Dave.

Change one cell's format based on value of another without cond fm
 

Hi JoAnn
Try looking he
http://www.mvps.org/dmcritchie/excel/event.htm



"JoAnn" wrote:

Using Excel 2003 with XP.

Cell J contains a value
Cell I contains a date

I want to have the date in "I" appear in bold, red font if the value in J
is < 3.
How can I do this without conditional formatting (already used up my 3
conditions)?

This needs to apply to all rows in the sheet. If there's a way to make it
happen as the information is entered (J is automatically populated by
information entered in G/H), that would be great.

I realize it will require a macro, I just can't figure out how to do it.

Thanks!
--
JoAnn

Change one cell's format based on value of another without con
 

Thanks, I will try that.
--
JoAnn


"Ron@Buy" wrote:

Hi JoAnn
Try looking he
http://www.mvps.org/dmcritchie/excel/event.htm



"JoAnn" wrote:

Using Excel 2003 with XP.

Cell J contains a value
Cell I contains a date

I want to have the date in "I" appear in bold, red font if the value in J
is < 3.
How can I do this without conditional formatting (already used up my 3
conditions)?

This needs to apply to all rows in the sheet. If there's a way to make it
happen as the information is entered (J is automatically populated by
information entered in G/H), that would be great.

I realize it will require a macro, I just can't figure out how to do it.

Thanks!
--
JoAnn