Conditional format

[Techtrend]

Hello team

With higher highs and lower lows need to Highlight Cells which are changing positive to negative and Negative to positive ,

The details are mentioned in the attached document

Thanks In advance
Narendra

 

[PCosta87]

Hi @Techtrend

For values that are negative in G and are now positive in L use the following as formula in conditional formatting (don't use $ so you paste format to the other cells in column L):

=E(G2<0;L2>0)
and format as you like

For the opposite use:

=E(G2>0;L2<0)
and use different format than above

If I understood correctly this should do the trick

Let me know if it was any help

 

[Techtrend]

Costa

Thanks for the solution.

Thanks
Narendra

 

[Khalid NGO]

=E(G2<0;L2>0)

=E(G2>0;L2<0)

Hi PCosta,

I am not getting this

Do you mean AND ?

Regards,

 

[pecoflyer]

Do you mean AND ?

Looks like the Portuguese version of AND

 

[PCosta87]

Hi PCosta,

I am not getting this

Do you mean AND ?

Regards,

Sorry, it is portuguese and I forgot to change it (now that is a first)
I meant "and"

Sorry again

 

[Khalid NGO]

@PCosta87
No problem dear

Thanks for the clarification.

Regards,