| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Have row color change to one of 8 different colors based on one cell's value (I, O, C, T, L, E, X, A) | Excel Discussion (Misc queries) | |||
| Conditional Format based on other cell's value | Excel Worksheet Functions | |||
| How to change cond. format icons in EXCEL 2007? | Excel Worksheet Functions | |||
| change format of cells (bold, italic) based on one cell's answer | Excel Discussion (Misc queries) | |||
| Change value based on another cell's value | Excel Discussion (Misc queries) | |||
Threaded Mode
