Forum Discussion

CDMKR's avatar
CDMKR
Copper Contributor
Aug 05, 2022
Solved

Gas mileage chart

I have a column range for varying gas prices in  column G  Is there a way to search the column to find lowest pump price and mark in green font  to find the highest pump price and mark in red font in...
excel
Formulas and Functions
  • mathetes's avatar
    mathetes
    Aug 05, 2022

    CDMKR 

     

    Yes. Conditional formatting would do that. As shown here. You'll need to modify the formulas to fit your specifics (I did the reverse of your color scheme, for one), but this illustrates the "how".

     

HansVogelaar's avatar
HansVogelaar
MVP
Aug 05, 2022

CDMKR 

Let's say the gas prices are in G2:G40.

Select this range. G2 should be the active cell in the selection.

 

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula

=G2=MIN($G$2:$G$40)

Click Format...
Activate the Font tab.
Select green as highlight color.
Click OK, then click OK again.

 

Repeat these steps, but with the formula

=G2=MAX($G$2:$G$40)

and red as color.

Resources