So I have a table. In "Column 1", I have a range of names for example, Vera Manning, Curtis Daniels, Holly Howell.
In "Column 2", I have numbers ranging from 1-10000$.
What I want to do is to colour both columns IF "Column 2">5000 AND "Column 1" (IS not Vera Manning), Red ())
So essentially, anything that is over 5000 AND does not have Vera Manning's name in Column 1 , I want the entire (e.g. Curtis Daniels and amount of 6000) row to be highlighted red if possible. If not, at least the amount is highlighted.
How do I do it?
Thanks it helps! Another issue I have, In Column 1, I have a range of names. In Column 2, I have a range of numbers
What I want to do is IF (Column 1 <> 'Vera Manning, Curtis Daniels, Holly Howell' , Red () )
So essentially, if the names are not Vera Manning, Curtis Daniels or Holly Howell. I want to make the any other names or numbers red.
Not sure if you solved your issue. But if you have would you mind closing the thread.
In a situation like that I would do something with the data itself. Create a flag field with a value of 1 for all the names that you want on your list. Hopefully, you can do that programmatically.
Then just check for the value of that new flagged field.