If Kaiser is entered in Column C, I want column F's figure to be displayed in
red. Does anyone know how to write formula? I am not that experienced with
formulas but know it can be done.

C D E F
Anthem 44115 #N/A $123.00
UHC 44511 #N/A $1,234.00
Aetna 44623 #N/A $12,345.00
Kaiser 130021 #N/A $45,646.00

Thanks!