I am not sure what you are asking for. I opened the workbook, changed cell G4 to -100 and all the highlighed cells on row 9 turned red...

Would you please clarify