macro for unpaid rent

C

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

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
Click to expand...
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.
 
Top