I have a spreadsheet in which I enter daily closing stock prices.

I want to be able to automatically have the cell fill with a color that indicates whether the current day's closing price is one of the following:

1. Higher than the previous day's closing price
2. Lower than the previous day's closing price
3. The same as the previous day's closing price

I have attached part of the spreadsheet I use (and manually fill in the current day cell color based on closing price change from the previous day's closing price). There are days with no data - SAT, SUN, holiday that need to be accounted for so that the correct previous day is referenced.



I appreciate the help.

Thanks.

Attached Files

092318_Excel_Forum_Sample_Spreadsheet.xlsx (10.2 KB, 13 views)