In the file named Problem29data.xlsx, columns EI contain the following information: The opening price of a stock

Question:

In the file named Problem29data.xlsx, columns E–I contain the following information:

The opening price of a stock

Whether we owned stock at the beginning of the day

Whether we sold the stock that day

Whether we owned the stock at the end of the day

Use conditional formatting to highlight each row of data for days the stock was sold.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: