Conditional formatting

Closed
airnewtown Posts 1 Registration date Saturday November 1, 2014 Status Member Last seen November 1, 2014 - Nov 1, 2014 at 11:31 PM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Nov 3, 2014 at 09:23 AM
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

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Nov 3, 2014 at 09:23 AM
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
0