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

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!
 
D

Dave

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible Conditional Formatting Workaroud? 1
Color Coding cell based on date (over a large range) 3
Trying to run excel vba code when cell value changes from empty to entered value. 1
Conditional Formatting Not Working As Intended 3
Incrementing a cell based on another cell's value 0
Automatic Cond Formatting of multiple columns based of values of 1 2
Conditional Format? 4
Cond Format -- on set of columns, then one column 3

Top