If function & Conditional formatting

[agroeneveld]

See attached spreadsheet.

Column C contains a formula that determines Coverage Rate based on position and annual earnings.

I want column B to automatically auto populate the answer Yes if Column A = 1,

But if column A = 2, I need the appropriate cell in column B to be highlighted.

Basically, if the Class = 2, they have the option to reject coverage.

[FDibbins]

You already have a DD in B, but use this...
=IF(A2=1,"Yes","No")

For the highlighting...
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A2=2 format fill your color choice

[agroeneveld]

How can I adjust the formula so that if Nothing is entered in Column A, then Nothing will appear in Column B?

[JeteMc]

Try modifying the formula so that it reads:

Please Login or Register  to view this content.

Let me know if you have any questions.