Forum Discussion

williamhill43's avatar
williamhill43
Copper Contributor
Aug 25, 2022

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?

 

  • 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.

Resources