Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
144
Views
Topic starter
Hello,
I need code for data validation to put color in the cell
I explained in the picture
Thank you in advance for your reply
Posted : 09/07/2021 7:19 am
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
Posted : 09/07/2021 8:19 am
Topic starter
Mr. Anders your code is 100% works for me and my problem is full solved
Thank you very much for your help
Posted : 09/07/2021 10:04 am
