Color a cell based off of a number between 2 numbers.

Copper Contributor

Back again with the coloring a cell questions. In the example below I need to change the color of cell G2 to yellow because it's between 0 and 15. The formula to get the number 6 in cell G2 is =F44-TODAY() and based off of the date in cell F2 and todays date. So how do I conditionally format the cells in column G to change to yellow if between 0 and 15?



1 Reply


Select the cells that you want to format. I will assume that G2 is the active cell in the selection.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.
Enter the formula


Click Format...
Activate the Fill tab.
Select yellow as highlight color.
Click OK, then click OK again.