View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
JoAnn JoAnn is offline
external usenet poster
 
Posts: 78
Default 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