Conditional formatting
Closed
airnewtown
Posts
1
Registration date
Saturday 1 November 2014
Status
Member
Last seen
1 November 2014
-
1 Nov 2014 à 23:31
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 3 Nov 2014 à 09:23
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 3 Nov 2014 à 09:23
Related:
- Conditional formatting
- Excel clear formatting - Guide
- Excel conditional formatting based on date - Guide
- Excel conditional formatting dates overdue ✓ - Excel Forum
- Formatting windows 7 - Guide
- Conditional formatting between two values ✓ - Excel Forum
1 response
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
3 Nov 2014 à 09:23
3 Nov 2014 à 09:23
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
