View Single Post
Old 06-17-2018, 08:45 AM
OldIronBoots OldIronBoots is offline Windows 10 Office 2016
Join Date: Jun 2018
Posts: 1
OldIronBoots is on a distinguished road
Default Referencing Entire Columns in Excel Formula w/ Conditional Fomating


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~
Reply With Quote