|
|
#1
02-20-2018, 08:49 AM
|
|||
|
|||
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.
|
|
#2
02-20-2018, 09:37 AM
|
||||
|
||||
|
Try =$G$27>0.21 as formula
__________________
Using O365 v2503 - 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
|
|
| 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 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.
|
Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
Windows 10 
Office 2013
Linear Mode
