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 1983 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 3, 2014 at 09:23 AM
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Nov 3, 2014 at 09:23 AM
Related:
- Conditional formatting
- Excel clear formatting - Guide
- Excel conditional formatting based on date - Guide
- Risk formatting excel - Excel Forum
- Conditional formatting between two values ✓ - Excel Forum
- Conditional formatting if cell contains text ✓ - Excel Forum
1 response
Mazzaropi
Posts
1983
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
