Font color change automatically based on specific keyword

Hi,
Is there any way that your data font color is automatically changed based on specific keyword?


Regards

You probably would need VBA for that

Try the attached as an approach.
Do your data entry on sheet one.
The keywords and their associated colours are on sheet two.
The colour format is RGB.
The VBA is using the Worksheet_Change event.
Non keywords default to font colour black.
torachan.

Thank you torachan (and Pepe Le Mokko too) for your kind responses. The problem is I do not know VBA, so is there any other way to use excel formulas/functions to achieve this?

Regards

Thank you torachan for your kind response. The problem is I do not know VBA, so is there any other way to use excel formulas/functions to achieve this?

You cannot use an in cell formula, but you could use potentially conditional formatting.
Can you upload a sample workbook, showing what you want.