Is it possible to display a text message based on condiiton format

I used conditional formating to shade the cell in red when the cell value is >5, if it exceeds then it should display a error message. Is it possible n conditional formating or do i need to write macros