Coloring a cell

Hi. I am new to VBA for Excel. Question : how do I color a cell based on certain conditions. For instance, if cell A1 = "123", then color cell A5 red. Thanks for your help!

hi grumpyguppy,

welcome to the forum

you do not need vba

select a5 then goto > format> conditional formating>formula is

then type in =$a$1=123 the select format, patterns , select red

steve