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!