Hi,

First Select from Step 2 to Step 7 and type this (=$AC$2="cold") formula in conditional formatting.

And Select from Step 4 to Step 7 and type this (=$AC$2="hot") formula in conditional formatting.

Finally, font and border and background color have must change to white color in conditional formatting.