
Anders Sehlstedt
Eskilstuna, Sweden
VIP
Members

Trusted Members

Trusted Members

Forum Posts: 873
Member Since:
December 7, 2016
December 7, 2016

Hello,
You can read more about conditional formatting here.
The formula needed to check for the two conditions you look for to add light red background for G column is following:
=OR(AND($C2="LONG",$G2<=$J2),AND($C2="SHORT",$G2>=$J2))
Br,
Anders

Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Alain Balken, David du Toit
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Karen Newman
Aminu Sule
Samuel Ramirez
Abdifatah Osman
mohad borhom
Abayomi Adedeji
Ganesh MVS
Gilbert Lemek
Ashleigh Farquharson
Jayz Luu
Forum Stats:
Groups: 3
Forums: 24
Topics: 6364
Posts: 27830
Member Stats:
Guest Posters: 49
Members: 32347
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
