Kimber
Member
This is my first time to post a question, so please forgive me if my question is unclear.
Currently, I print PDF reports sent to me each morning from the AS400. The report shows the planned daily average quantity (per day) and the actual daily average. Each morning I print this report and highlight in pink if the daily average is below the plan and yellow if the daily average equals or surpassed the plan. I am unable to post a sample, but this is a cumulative report per period. Each day a row is added for that period until we reach the production period end and start over the following month with just one entry. Considering this is a new document each day, is there a way to include conditional formatting for the plan cell and the last daily average cell (the formula looks for the newest number in the column section)?
Currently, I print PDF reports sent to me each morning from the AS400. The report shows the planned daily average quantity (per day) and the actual daily average. Each morning I print this report and highlight in pink if the daily average is below the plan and yellow if the daily average equals or surpassed the plan. I am unable to post a sample, but this is a cumulative report per period. Each day a row is added for that period until we reach the production period end and start over the following month with just one entry. Considering this is a new document each day, is there a way to include conditional formatting for the plan cell and the last daily average cell (the formula looks for the newest number in the column section)?
