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.

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