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.

-----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.