Is it possible to have the text of a cell stipulated/populated via conditional formatting?
I still need the cell to be manually filled by other text as needed by the user, but have the capacity to fill itself based on the value of another cell.

SO! Example time:

I need cell C5 to populate as "Meetings", but only under the condition that cell A5 states "Meetings". So, if A5 specifies something else, like a customer name, for example, then C5 can still be filled as necessary by the user.

I'm honestly not sure whether this is possible or not. It would need to be conditional formatting or something similar. Macros are a no-go as a lot of our users aren't macro compatible (or rather, their copies of Excel/laptops).