Nov 10 2020 05:28 AM
Nov 10 2020 05:46 AM
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter a formula like this:
using your specific requirements of course.
Activate the Fill tab.
Click OK, then click OK again.