Hi Daveed,
Use conditional formatting.
Select the cells in row 1 that you want formatted this way.
In the main menu bar go FormatConditional formatting...
Click on the down arrow and select Formula Is.
In the box to the right of Formula Is type =$L$10
Click on the Format... button then make the changes for red, bold font
then click OK.
Click OK

Ken Johnson