Referencing Entire Columns in Excel Formula w/ Conditional Fomating

[OldIronBoots]

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~

[Debaser]

You should specify a row number which is the same as the first cell in your selection when applying the CF. For example:

=AND($C2=[PRICE],$D2="[WORDS]")

Note that there is no $ in front of the row number, so it adjusts for each row to which the CF is applied.