Good Day,
I am trying to apply conditional formatting to cell K. IF cell C is greater than or equal to cell N and cell K equals ENTERED I need the cell in column K to be highlighted. I have made many attempts and read just about everything I could find on-line and in the Excel Bible. Originally I was thinking the IF(AND) nested statement however that only caused error codes and through reading went to the AND statement. I tried just using an AND statement (as both conditions are TRUE), no errors but no results either. Any advise on how to get this accomplished?
I am trying to apply conditional formatting to cell K. IF cell C is greater than or equal to cell N and cell K equals ENTERED I need the cell in column K to be highlighted. I have made many attempts and read just about everything I could find on-line and in the Excel Bible. Originally I was thinking the IF(AND) nested statement however that only caused error codes and through reading went to the AND statement. I tried just using an AND statement (as both conditions are TRUE), no errors but no results either. Any advise on how to get this accomplished?