Forum Discussion
Color a cell based off of a number between 2 numbers.
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?
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.
