macro for unpaid rent

[constance]

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.

 

[bobf]

-----Original 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.
.
No need for a macro. Use conditional formatting, based on

finding "no" in the paid column, to format the cells as
above. You can have 3 condition tests, plus the natural
cell border and fill formatting.