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.