Conditional formula (IF) and conditional formatting

Follow the instruction inside the workbook and upload the completed file (Book2 - IF.xlsx).

You don't need to rename the file but please recheck if you uploaded the correct one.