Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-20-2018, 08:49 AM
derohanes derohanes is offline Conditional formatting Windows 10 Conditional formatting Office 2013
Advanced Beginner
Conditional formatting
 
Join Date: Oct 2008
Posts: 67
derohanes is on a distinguished road
Default Conditional formatting


I can't figure out why this is not working. I have a cell that sums 3 other cells. If that sum is greater 21%, I want the cell to have a red fill and white font. attached is a pic of the cells I'm summing, and the conditional statement. I have also tried to use the ">0.21" syntax with no luck. I'm missing something.
Attached Images
File Type: png Untitled-1.png (1.7 KB, 14 views)
File Type: png Untitled.png (10.6 KB, 14 views)
Reply With Quote
  #2  
Old 02-20-2018, 09:37 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,632
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Try =$G$27>0.21 as formula
__________________
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
Help with if and conditional formatting piper7971 Excel 11 06-10-2015 12:07 AM
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 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 01:10 AM.


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