Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-23-2016, 07:54 AM
dayperson dayperson is offline Conditional formatting Windows 8 Conditional formatting Office 2013
Novice
Conditional formatting
 
Join Date: Feb 2016
Posts: 1
dayperson is on a distinguished road
Default Conditional formatting


if a3 is < 100 then a4=10.00 otherwise show 0.00
Pieces Under $100 Over $100 $10.00 $0.00 $10.00 $0.00 $10.00 $0.00 $10.00 $0.00
Reply With Quote
  #2  
Old 02-23-2016, 09:07 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional formatting Windows 7 64bit Conditional formatting Office 2010 64bit
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

Hello to you too

Could you be a little more explicit please, my crystal ball is not working

From what I understand =IF(A3<100,10,0) placed in A4 ?
__________________
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 Conditional formatting bbutl027 Excel 15 12-05-2016 08:56 PM
Conditional Formatting sdfrance Excel 3 01-06-2015 07:10 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 namedujour Excel 3 08-25-2011 01:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:59 PM.


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