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

Occasional 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?

 

Capture2.PNG

1 Reply

@williamhill43 

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

=AND(G2>=0,G2<=15)

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