![]() |
#1
|
|||
|
|||
![]() 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~ |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
ross.lowe | Excel | 1 | 02-21-2017 09:34 AM |
![]() |
tdodson | Excel | 2 | 10-27-2015 09:38 PM |
Naming Cells for formula referencing | lynchbro | Excel | 6 | 06-26-2014 07:45 AM |
Referencing a value over 255 characters within a table PLUS strange formula behaviour | TishyMouse | Excel | 2 | 01-08-2013 09:39 AM |
Excel Formula - Conditional replacement of cells | mag | Excel | 0 | 10-27-2012 08:30 PM |