- Format font colour to change
- Changing font colour (Solved) » Forum - Office software
- Change the rows font colour based on one cell » Forum - Excel
- Format fill colour based on another cell (Solved) » Forum - Excel
- Conditional Formating: formula cell text change color (Solved) » Forum - Excel
- Unable to change date format in Excel [Solved] (Solved) » Forum - Excel
2 replies
Best answer
Jerry, Good afternoon.
You must use the Conditional Format to have what you need.
Select K2:K15 to apply the CF.
Menu Conditional Format
Using Formula
=K2>$L$2
Select colour format as desired
OK
Please, tell us if it worked as you desire.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
You must use the Conditional Format to have what you need.
Select K2:K15 to apply the CF.
Menu Conditional Format
Using Formula
=K2>$L$2
Select colour format as desired
OK
Please, tell us if it worked as you desire.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
has helped 2134 users this month
Report
Worked great! Thank you!!