Macro for changing colour of a cell

Report
Posts
1
Registration date
Monday December 6, 2021
Status
Member
Last seen
December 6, 2021
-
Hello,
I'm am trying to fix a spread sheet at work but what i need is a macro that i can run
to do the following

if the word Traffic appears in Column E then the cell on the same row but in Column H turns black

thanks in advance for any help with this