Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-17-2018, 08:45 AM
OldIronBoots OldIronBoots is offline Referencing Entire Columns in Excel Formula w/ Conditional Fomating Windows 10 Referencing Entire Columns in Excel Formula w/ Conditional Fomating Office 2016
Novice
Referencing Entire Columns in Excel Formula w/ Conditional Fomating
 
Join Date: Jun 2018
Posts: 1
OldIronBoots is on a distinguished road
Default 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~
Reply With Quote
  #2  
Old 06-18-2018, 03:42 AM
Debaser's Avatar
Debaser Debaser is offline Referencing Entire Columns in Excel Formula w/ Conditional Fomating Windows 7 64bit Referencing Entire Columns in Excel Formula w/ Conditional Fomating Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Posts: 172
Debaser is on a distinguished road
Default

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

Thread Tools
Display Modes


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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft