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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 3, 2014 at 09:23 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 3, 2014 at 09:23 AM
Related:
- Conditional formatting
- Excel conditional formatting based on date - Guide
- How to clear formatting in excel - Guide
- Formatting windows 7 - Guide
- Hp formatting tool - Download - Storage
- Formatting sd card to fat32 - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Nov 3, 2014 at 09:23 AM
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
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
