Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-11-2015, 11:12 AM
Triscia Triscia is offline Conditional format a button based off a value in a field Windows 7 32bit Conditional format a button based off a value in a field Office 2007
Novice
Conditional format a button based off a value in a field
 
Join Date: Jan 2013
Posts: 4
Triscia is on a distinguished road
Default Conditional format a button based off a value in a field

I am trying to conditional format a button based off of a specific field. That field displays as a percentage with two decimal places, example 89.93. If the result in that field is 89.99 or below I want the specific button to fill red, if the field is between 90.00 and 94.99 then the button will be yellow and if the field is 95.00 then the button should be green. I have tried so many different scenerios, that I am at a lost. Does anyone know how to do this? I have seven different spots that I need this to work. TIA!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional format a button based off a value in a field Conditional Formatting based on dynamic Date Modifier1000 Excel 2 09-12-2014 08:53 AM
Creating new field in pivot table based off existing field laceymarie1987 Excel 0 06-26-2014 12:13 PM
Conditional Formatting based on Value of Another Cell SteveBump Excel 3 03-07-2014 09:16 AM
Conditional format a button based off a value in a field How can I count cells based on their fill color that was set by conditional format trueimage Excel Programming 1 10-25-2013 12:08 PM
Conditional format a button based off a value in a field Conditional formatting question based on cell date Cosmo Excel 2 04-08-2013 12:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft