Forum Discussion

herrerany's avatar
herrerany
Copper Contributor
May 06, 2020
Solved

CHANGING COLOR TO RED OF FORMULA RESULT

I HAVE THIS FORMULA =D2*100/C2 ON H2. HOW TO MAKE THE RESULT CHANGE TO RED IF H2>29.99?  COULD I USE AN IF FORMULA AS =IF((D2*100/C2)>29.99,RED(CODE FOR THIS COLOR),BLACK(CODE FOR THIS COLOR)
Formulas and Functions
  • mtarler's avatar
    mtarler
    May 07, 2020

    herreranyI would use conditional formatting.  on the 'home' tab, select conditional formatting - highlight cell rules - greater than

mtarler's avatar
mtarler
Silver Contributor
May 07, 2020

herreranyI would use conditional formatting.  on the 'home' tab, select conditional formatting - highlight cell rules - greater than

herrerany's avatar
herrerany
Copper Contributor
May 07, 2020

WORKED LIKE A CHARM, THANK YOU mtarler 

Resources