Thread: [Solved] Conditional formatting
View Single Post
 
Old 02-20-2018, 08:49 AM
derohanes derohanes is offline Windows 10 Office 2013
Advanced Beginner
 
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