Log In
Register
Home
Active Member
February 22, 2012
Offline
I have tried different formulas to get this to work using AND/OR but cannot seem to get it to work.
I have a file attached an example
Will wildcards work?
What if my criteria was a number such as 123 in line 3
October 5, 2010
Offline
Hi Robert,
The syntax for OR is
=OR(Condition1, Condition2)
so something like
=OR(A1=123, B1="xyz")
Your first OR formula is
OR($A2,A2="wa")
But the value in $A2 is a string so this isn't really carrying out a test as I think you intend. What value do you want to check for in $A2?
With OR($B2,B2="true")
B2="true" is saying check B2 for the text "true", but I assume you want to test for the Boolean value True.
I'm not sure what you are trying to test for. if you can explain that I can probably rebuild the formula for you. Please provide a few examples.
Regards
Phil
Active Member
February 22, 2012
Offline
Let me preface this with an explanation;
I wrote a powershell script to query an Active Directory server for status of user accounts; Who, what, when, where and status etc...
"True" or "False" is just a response of the status of the account in the .csv results.
$A2 is looking for any instance of ".wa" at the end of the string.
"true" is not a boolean value
What I am trying to do is highlight any text in $A2 ending with .wa, .oa, .sa in letters in "red" that are also "true" in $B2.
I think I will need three different conditional rules for each of the above.
.wa and .oa and .sa are the type of account
October 5, 2010
Offline
Hi Robert,
The formula you need to make the text red under those conditions is:
1 Guest(s)
