| 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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| 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) | |||
Hybrid Mode
