Good morning everyone --

First time post, so hopefully I am following the guidelines correctly. I am a relative newb to using Excel as a tool to my business, but am picking up the details quickly (but not quickly enough).

I have a 2-parter here. Attachment 378806

I want my spreadsheet to be able to read Column A, and based on the Column A data which will read Saturday, Sunday, or Saturday/Sunday (more on that below), to format column J data to either Yellow or Peach. If the value in Cell A2 to Ainfinity = "Saturday" then the Cell in Column J associated with the Cells in Column A should change to Yellow. If the Value in Cell A2 to Ainfinity equals "Sunday" then the Cell in Column J associated with the Cells in Column A should change to Peach.

Column A is Open House Day. Column J is the Neighborhood with which the Open House is.

In addition to this (and maybe this should be the first step in this process, if the data in Cells A2 to Ainfinity equal "Saturday/Sunday" I need to have that whole row to be duplicated and added after the last row of Data.

I will attach a sample spreadsheet so you can see what I am talking about. There are 4 tabs. Tab 1 & 2 pull data from Tab 3. Tab 4 (the Tab in question above) pulls data from Tab 1.

If you need anything else from me, please don't hesitate to ask.

Thank you so much!
Steve

DP_OHList_2.14.xls