Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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

All times are GMT -7. The time now is 09:55 PM.


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