Assuming that C2:F5 contains the data, try the following...

1) Select F2:F5, making sure that F2 is the active cell

2) Format Conditional Formatting Formula Is

3) Enter the following formula:

=$C2="Kaiser"

4) Choose your formatting

5) Click Ok

Hope this helps!

In article ,
JS wrote:

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!