#1
|
|||
|
|||
IF-AND-OR Function Help for Status
Trying to build a status spreadsheet that will eventually feed a SharePoint site dashboard. I am trying to figure out how to display color in D3 based on the 1-4 conditions in A3 when compared to a numerical value in B3. I have filled out what I believe are all the conditions possible in column D. Is this done using the functions or should I be researching on how to build a VBA?
TIA Steve |
#2
|
||||
|
||||
Hi
what does this sign mean in your table ? >< ? Different from ? So ><7-11 would be not between 7 and 11 ? I don't get it
__________________
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 |
#3
|
|||
|
|||
Pecoflyer,
The ><7-11 means greater than 7 and less than 11. When the value is in the range then I get the color. Trying to learn proper formatting for formulas, so any pointers would be appreciated. |
#4
|
||||
|
||||
What is the relation between Your date range and the drop-down? I can't get the logic
__________________
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 |
#5
|
|||
|
|||
Pecoflyer - No relation between date range and drop-down list. The thought process is a team member selects status from the drop-down in column A and puts the date they checked the system in column C. Using the date the spreadsheet is opened cell A1(=Today()) and the date in column C I get a column B number of days since last check. Using one of the date ranges in column G cells and comparing it to the status in column A I get a color displayed in column D. As an example I select Operational in column A put a date in column C and I open the spreadsheet and it has been 12 days since the last system check I get yellow in Column D. TIA for the help.
|
#6
|
||||
|
||||
Like this? I played around with the number of days, as the last update is unchanged.
Just remove the extra number I subtracted and review the update
__________________
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
status bar | Herm61 | Word | 2 | 03-24-2018 02:18 PM |
Restrict Editing function disable insert textbox function | IanM_01 | Word | 5 | 11-21-2015 02:29 AM |
Page in status bar is wrong; other status bar errors, as well | amz | Word | 3 | 08-12-2015 02:27 PM |
#REF! Error in calling VBA function disappears when function is copied | lcaretto | Excel Programming | 2 | 05-26-2014 07:19 PM |
Creating a graph for Future Value function (FV function) | bmoody | Excel | 2 | 11-06-2013 10:52 AM |