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
 

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:37 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