Answered: Need help with Excel conditional…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Need help with Excel conditional formatting. I have already posted this question once and they just did a copy and pasted general excel help guide which didn't cover the issue. Below the initial question are more details clarifying since I evidently did a bad job clarifying. Need to find the conditional formatting function to use in an Excel to input to change dates within multiple columns/rows to fill red for dates that past current date, yellow for coming due within next month, and green for further out. Column F, row 2 thru Column T Row 391 Ex. $F$2:$T$391 End result is any dates that are overdue (beyond today's date) in column rows $F$2:$T$391 need to be Red fill. Any dates that are within the next month need to be Yellow Fill, and any dates that are more than a month from today are green fill with is each updating for the current date.

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions