Thread: IF-AND-OR Function Help for Status
View Single Post
 
Old 12-30-2021, 10:38 AM
SJC1340 SJC1340 is offline Windows 10 Office 2019
Novice
  
Join Date: Dec 2021
Posts: 3
SJC1340 is on a distinguished road
Default 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
Attached Files
File Type: xlsx Status Workbook.xlsx (11.8 KB, 17 views)
Reply With Quote