Forum Discussion

packie's avatar
packie
Brass Contributor
May 17, 2023

Need a formula to highlight cell

Hi,


I need some help in creating a formula.

 

Example:

 

H4 contains the value 10%

G5 contains the value 50

D5 contains the value 42

 

H5 is where the formula goes:

 

When G5 is less than H4 and is less than D5 then highlight the cell

 

I have attempted to create the formula but got stuck on how to incorporate D5

 

=$G5*(1-H$4)

 

Thanks for any help!

Patrick

 

Excel
Formulas and Functions
  • packie's avatar
    packie
    Brass Contributor
    May 17, 2023
    At the moment the formula =$G5*(1-H$4) will return 45
    so therefore 50 (G5) less 10% (H4) will return 45

    So what I need to know is 45 (H5) equal or more than 42 (D5) and in this example it is more so therefore highlight cell H5

Share

Resources