I have the following formula in B6...
=IF(G6<>""," Company Name: ","YOU MUST ENTER A COMPANY NAME IN G6!")
When there is no value in G6, I want the text in B6 to be in red. I know you can do this with Conditional Formatting but I just do not remember how.
I have attached the file showing the example in B6