Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-23-2016, 07:54 AM
dayperson dayperson is offline Windows 8 Office 2013
Novice
 
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 Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,329
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
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 ?
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting bbutl027 Excel 15 12-05-2016 08:56 PM
Conditional Formatting sdfrance Excel 3 01-06-2015 07:10 AM
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


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft