Need to find the conditional formatting function to use in an Excel to input to...

60.1K

Verified Solution

Question

Accounting

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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students