#1
|
|||
|
|||
Referencing Entire Columns in Excel Formula w/ Conditional Fomating
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~ |
#2
|
||||
|
||||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
NEED: Formula for referencing data in two files | ross.lowe | Excel | 1 | 02-21-2017 09:34 AM |
Create formula for entire column | 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 |