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)

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

Forum Discussion

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
May 07, 2020
herreranyI would use conditional formatting. on the 'home' tab, select conditional formatting - highlight cell rules - greater than

2 Replies

mtarler
Silver Contributor
May 07, 2020
herreranyI would use conditional formatting. on the 'home' tab, select conditional formatting - highlight cell rules - greater than
- herrerany
  Copper Contributor
  May 07, 2020
  WORKED LIKE A CHARM, THANK YOU mtarler