Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-22-2022, 03:47 PM
JHalter JHalter is offline Windows 10 Office 2019
Advanced Beginner
Conditional Formatting
 
Join Date: Nov 2021
Posts: 46
JHalter is on a distinguished road
Default Conditional Formatting

In column G, I want the cell to be highlighted green if the number in column C is less than one. How do I set up a formula for this?
Reply With Quote
  #2  
Old 08-22-2022, 07:39 PM
Guessed's Avatar
Guessed Guessed is offline Conditional Formatting Windows 10 Conditional Formatting Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Select column G and Add a new Conditional Format rule.
Choose a formula and set the Format you want to see
In the formula box put in a formula using the first cell that aligns with the top of your selection eg
=$C2<1
which assumes the first row of your selection is row 2.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 08-23-2022, 12:17 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional Formatting Windows 7 64bit Conditional Formatting Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
Originally Posted by Guessed View Post
Select column G and Add a new Conditional Format rule.
Choose a formula and set the Format you want to see
In the formula box put in a formula using the first cell that aligns with the top of your selection eg
=$C2<1
which assumes the first row of your selection is row 2.
Proceeding this way will format every empty cell also, especially when selecting an entire column ( which to me is bad practice).
You could (eventually) make your range an Excel table (allowing automatic extension of the rules) then click Conditional Formatting - Highlight cell rules - Between and enter 0 as lower limit and 1 as upper limit. Format as required
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #4  
Old 08-23-2022, 07:57 AM
JHalter JHalter is offline Windows 10 Office 2019
Advanced Beginner
Conditional Formatting
 
Join Date: Nov 2021
Posts: 46
JHalter is on a distinguished road
Default

Thanks! This is very helpful!
Reply With Quote
  #5  
Old 08-23-2022, 10:15 AM
JHalter JHalter is offline Windows 10 Office 2019
Advanced Beginner
Conditional Formatting
 
Join Date: Nov 2021
Posts: 46
JHalter is on a distinguished road
Default Conditional Formatting

In column G, I want the cell to turn green if "bulk" is written in Column I, how do I set up this equation.

Thanks!
Reply With Quote
  #6  
Old 08-23-2022, 11:17 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional Formatting Windows 7 64bit Conditional Formatting Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Range : col G - Condition =$I1="bulk" ( adapt ranges as required and don't use entire columns)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting RocketRon Excel Programming 2 11-25-2019 08:36 AM
Conditional Formatting Conditional formatting marif300 Project 9 09-23-2014 07:23 AM
Conditional Formatting Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
conditional formatting otuatail Excel 1 06-06-2012 05:07 AM
Conditional Formatting Conditional Formatting. Laurie B. Excel 6 04-09-2012 05:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:38 AM.


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