Conditional Formatting is greyed out
Shared Workbook
Similarly, if a workbook is shared, you won’t be able to use Conditional Formatting.
To stop sharing your workbook, in the Ribbon, select Review > Unshare Workbook.
You can then use Conditional Formatting.