Good afternoon, I’m updating a document I created a few years ago and am trying to utilize the conditional formatting function. I have two adjacent cells, say A1 and A2, where A1 is a primary data field and A2 is a secondary filed. I have an accounting code entered in the first cell (A1) and want a PO number entered in the second cell (A2). Is it possible to have the second cell (A2) turn light red with the first cell (A1) has text and the second is empty? BTW, I am using the new version of excel so I am still trying to get use to the execution of some of these functions.

Thank you in advance for your help!