Cells H4:N4 contain one of the values derived from a validated list as follows:
(blank), X, WIP, AP and filled using conditional formatting as (no fill), green, yellow and red respectively.
To understand a little about what I am doing I offer the following. Blank means no value and there is no data. Green (X) means it is complete and work may continue. Yellow (WIP) is a work in progress and is not holding the job up. Red (AP) is awaiting parts and means a work stoppage.
On this detail sheet I want to be able to use cell O4 to find the worst case scenario from H4:N4 and indicate it in O4 then reference that format/value on a roll-up sheet; so if the worst case is "AP" then O4 will indicate either by value or format this condition. I then use that to roll up to the summary sheet.
The order of worst to best is AP, WIP, X, "Blank"
Any ideas?
(blank), X, WIP, AP and filled using conditional formatting as (no fill), green, yellow and red respectively.
To understand a little about what I am doing I offer the following. Blank means no value and there is no data. Green (X) means it is complete and work may continue. Yellow (WIP) is a work in progress and is not holding the job up. Red (AP) is awaiting parts and means a work stoppage.
On this detail sheet I want to be able to use cell O4 to find the worst case scenario from H4:N4 and indicate it in O4 then reference that format/value on a roll-up sheet; so if the worst case is "AP" then O4 will indicate either by value or format this condition. I then use that to roll up to the summary sheet.
The order of worst to best is AP, WIP, X, "Blank"
Any ideas?
