Good day. I'm new to this forum and somewhat new to excel. I did some project for my school but they were basic with no complications really.



My question is what function should I use so that specific row with information in 'F Colum' light up in red or yellow colors.

For example my F Colum will contain 'NOT' or 'Later' and will be selected from drop down list.

I would want my NOT to be in red and Later in Yellow.

Sorry if I missed anything to help you better understand this. Please let me know if any addition information is needed.

Thank you in advance.