Conditional formatting [Closed]

Report
Posts
1
Registration date
Saturday November 1, 2014
Status
Member
Last seen
November 1, 2014
-
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
This is my first post and I need some help please. How can I format excel so that if E3 ="STO" then I3 Formula =F2*100*G2-H2, IF NOT I3=F2*100*G2+H2.
Thank you.

1 reply

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
airnewtown, Good morning.

Try to do:
I3 --> =(F2*100*G2)+IF(E3="STO",-H2,+H2)

This formula works for you explanation.
BUT how you intent to use a CONDITIONAL FORMATTING?
It's not clear for me.

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!