Home |
Search |
Today's Posts |
#1
|
|||
|
|||
macro for unpaid rent
I need to create a macro to recored unpaid rent with a gray background red
text and border and bold style ,Rent is recorded as No in the paid column of the worksheet, any assistants would be appreciated. |
#2
|
|||
|
|||
You don't need a macro, use conditional formatting. Look up 'Highlight cells
that meet specific conditions' in the Answer wizard in help -- HTH RP (remove nothere from the email address if mailing direct) "constance" wrote in message ... I need to create a macro to recored unpaid rent with a gray background red text and border and bold style ,Rent is recorded as No in the paid column of the worksheet, any assistants would be appreciated. |
#3
|
|||
|
|||
"Bob Phillips" wrote: You don't need a macro, use conditional formatting. Look up 'Highlight cells that meet specific conditions' in the Answer wizard in help -- thank you but in this case I need to run a macro its a school assignment and my teacher is on spring break and cant help me with it.I can get the borders and text in the VBA editor but can't figure out how to get the no to run as unpaid. HTH RP (remove nothere from the email address if mailing direct) "constance" wrote in message ... I need to create a macro to recored unpaid rent with a gray background red text and border and bold style ,Rent is recorded as No in the paid column of the worksheet, any assistants would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro for unpaid rent | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
automatic macro update | Excel Worksheet Functions | |||
Date macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) |