 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008Conditional formatting: Less than, Greater than or "0".
I have a workbook with multiple spreadsheets. I need my cells to have conditional formatting. I have set up: If less than 0: Font should be Red If equal to 0: Font should be Black If more than 0: Font should be Green The less than and more than both work. The equal to turns green. How cab I make it turn black? Thanks, Debbie Your zeros are probably text instead of a number. Try putting quotes around your zero ("0") in the conditional formatting and see if it changes. HTH, Paul >I have a workbook with multiple spreadsheets. I need my cells to have > conditional formatting. I have set up: [quoted text clipped - 10 lines] > > Debbie I tried your suggestion. I changed the format to "0". When I looked back at the format it was changed to: ="'0'" And the condition was still green instead of black as I need. Debbie > Your zeros are probably text instead of a number. Try putting quotes around > your zero ("0") in the conditional formatting and see if it changes. [quoted text clipped - 16 lines] > > > > Debbie You might try change that condition to FormulaIs =INT(A1)=0 >I tried your suggestion. > I changed the format to "0". [quoted text clipped - 25 lines] >> > >> > Debbie That didn't work either. Any other suggestions? > You might try change that condition to FormulaIs =INT(A1)=0 > [quoted text clipped - 27 lines] > >> > > >> > Debbie You could remove the middle condition, as CF takes precedent, so if you have two conditions defined, one for greater than and another for less than, then if the value is equal to zero the normal cell format (set to black) will apply. Hope this helps. Pete > That didn't work either. > Any other suggestions? [quoted text clipped - 36 lines] > > - Show quoted text - Hi Debbie In Conditional Formatting 0 and nothing is the same. Regards Cimjet > You might try change that condition to FormulaIs =INT(A1)=0 > [quoted text clipped - 27 lines] >>> > >>> > Debbie Ok, now that I've wasted everyone's time... I figured it out. I have an "IF" statement that says if the cell is "0", enter a "0.00%". I'm so sorry. When I realized it, I was able to get my conditional formatting to work. Thanks so much for all your help. Debbie > Hi Debbie > In Conditional Formatting 0 and nothing is the same. [quoted text clipped - 31 lines] > >>> > > >>> > Debbie |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.