LinkBack URL
About LinkBacks
The logic is as follows If I2 ="Text" or "Text 2" and L2=0 --> Set l2 Format to RED Fill
My Formula
=AND($I$2="Purchase",L2=0)
If False = L1 is RED (should be L2)
Does not have the two option for texts
All blanks are format to red by default
The logic is as follows If I2 ="Text" or "Text 2" and L2=0 --> Set l2 Format to RED Fill
My Formula
=AND($I$2="Purchase",L2=0)
If False = L1 is RED (should be L2)
Does not have the two option for texts
All blanks are format to red by default
when you say L2=0 do you mean zero as in the number or empty?
if empty then you should use: =AND($I2="Purchase",$L2="")
If I've helped U pls click on d *Add Reputation
And I think the formula that you are looking for should be:
=AND(OR($I$2="Purchase",$I$2="Text 2"),L2=0)
The CF needs to be applied when I2 is selected.
Hope this helps.
Pete
Almost there. I just need to ada an OR to the final component l2=0 or l2= ""
=AND(OR($I$2="Purchase",$I$2="Text 2"),OR(L2=0,L2=””)) - This doesnt seem to work.
Is the Applies To = L:L ?
=AND(OR($I$2="Purchase",$I$2="Text 2"),OR(L2=0,L2=""))
=AND(OR($I$2="Purchase",$I$2="Text 2"),OR(L2=0,L2=””))
See de difference
The first works the second not
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
you can just use this:
=AND(OR($I$2="Purchase",$I$2="Text 2"),L2=""))
Thank you all. Closed
I was close :D
Glad it work..
Please mark this thread as Solved and consider giving a rep to those who've helped
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks