Question: Hello! I need a formula that will highlight the cell yellow in column A if it repeats 2 times within 90days from the current date.

Hello! I need a formula that will highlight the cell yellow in column A if it repeats 2 times within 90days from the current date. And will highlight red if a value in column A is repeated 3 or more times within the same time period.

thank you!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Daniel B. Butler and Freida C. Butler, husband and wife, file a joint return. The Butlers live at 625 Oak Street in Corbin, KY 40701. Dan's Social Security number is 111-11-1112, and Freida's is...

Data File needed for this Case Problem: NP_EX_2-4.xlsx TechMasters Javon Lee is the customer service manager at TechMasters, an electronics and computer firm located in Scottsdale, Arizona. Javon is...

answer it please : https://ccnymailcuny-my.sharepoint.com/:x:/g/personal/malam008_citymail_cuny_edu/Ea6JKeTr8SFHt2qszPDUavcBHxD6zFZUCXvCFivFNs4Kuw?e=h6i4EF 5 Write a formula in the yellow cell...

https://ccnymailcuny-my.sharepoint.com/:x:/g/personal/malam008_citymail_cuny_edu/Ea6JKeTr8SFHt2qszPDUavcBHxD6zFZUCXvCFivFNs4Kuw?e=Tedkm4 5 Write a formula in the yellow cell immediately be ow that...

I have this Accounts assignment that needs to be done. Need help on that Statement of individual work Individual work required This project is designed to assure that all students, individually, have...

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

this is one whole question; the image in the first photo is from the second photo Extend EX 2-51 everything that you need is right there Extend EX 2-51 IMG_20210403_0002.pdf and In the Lab, Module 2...

help please using excel asap problem 3 Problem S: (17 points - Project Planning Excel Tools) You just landed a job as the project manager for a national research lab. All project and operations use...

Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Downtown Office Supply Downtown Office supply is a small family owned store in a small suburb. In order to...

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

Assignment: Excel (75 points) Read the brief case below. Using the Excel spreadsheet provided, complete the questions. Downtown Office Supply Downtown Office supply is a small family owned store in a...

Henry (an Australian resident for tax) is 16 years old, and he is the sole beneficiary of the Herald Trust (the Trust). Tania is the trustee of the Trust. In 2020/21, the net trust income of the...

11.1.19e) Draw up the equation of the spherical surface: going through 4 points a(0,0,4), b(0,2,0), c(8,0,0) and d(-2,1,-1)

Seved Help Save 4 Exit Submit Check my work mode : This shows what is correct or Incorrect for the work you have completed so far, It does not indicate completion. Problem 1 3 - 2 5 Company Valuation...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...