Support Board

Date/Time: Thu, 09 May 2024 19:19:02 +0000

Post From: How to create alert background condition with one subgraphs or none

[2018-02-06 22:29:37] Link To Thread - Link To Post [Go To First Post]
User33743 - Posts: 83
Hi, TY for your time and helping me! Really appreciated! Am i right, or in previous version "=IF(OR(E3>B3,AND(B3>E4,B3=E3)),1,IF(OR(E3<B3,AND(B3<E4,B3=E3)),-1,T4))" "1" doesn't reffer to any cell? Should't this be: =IF(OR((E3>B3,AND(B3>E4,B3=E3)),1,T3),IF(OR(E3<B3,AND(B3<E4,B3=E3)),-1,T4)) ? I'm not sure how can i do this, where exactly can I put it? In color baground study? "You could then reference column T in your formula, now on the spreadsheet using the spreadsheet syntax, e.g. in cell U3: AND(ID1.SG14@3>0,T3=1)" I'm trying to get this ;)