Can anyone give VBA help on creating a macro?

To search the entire sheet and if any cell contains just an "A" turn the cell green. If it contains just an "R" turn the cell red.

If the cells contain anything thing else, do nothing.
For example "AM" then no change.

I can do this is conditional formatting, but I need a macro for it.