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

  • Thread starter Thread starter JoAnn
  • Start date Start date
J

JoAnn

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!
 
Hi JoAnn,
If you've already used your 3 conditions, you'd need to do it with VBA.
Regards, Dave.
 
Back
Top