Hello,
This is probably a dumb question but I've been looking online to reference a separate column and the column in question in order to give conditional formatting to the column in question.
So for example I want to say
if column C is a certain # && if column D is a certain combination of words, Fill Column C & D a certain color.
I'm not sure if able to fill the two columns with one formula so I would essentialy do the same thing twice but opposite in the two cell columns.
Here is what I have
"=AND($C:$C,
[PRICE],$D:$D="
[WORDS]") in conditional formatting
I have no formal training in Excel, so I might be completely off. Just a heads up.
Thanks for your time~