Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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, 16 views)
File Type: png Untitled.png (10.6 KB, 16 views)
Reply With Quote
 



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 12:23 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