Hello All,

I have a workbook in which i ask the user multiple questions. The only cells on the workbook that are unlocked are the ones that the user can enter data into. when the user opens the workbook he sees one question and a cell next to it say E3, that is highlighted. when the user input a value, text or numeric, whatever the question calls for, that cell is unhighlighted and the next question pops up and the next answer box is highlighted. they input the answer and the next question pops up and the next answer box is highlighted. I am making the questions pop up with if statements like =if(isnumber(E3),"This is the next question,""), and the highlighting move using conditional formating with the same concept as the last formula. This all works great in Excel 2010, but the problem comes when you put the program in excel 2007, the version in which most of my clients have, for some reason that i cannot figure out the conditional formatting of the highlighting the cells is not consistent and here is my post asking for help on that, http://www.excelforum.com/excel-gene...html?p=2794321. Therefore i figured i would just solve this problem with a little VBA. I am looking for something that will look in cell say E3 and if it is blank then fill the cell with neon yellow(Highlight), if it contains a value say text or numeric, then that cell will be unfilled and the next cell to be answered say E10, will be highlighted, and so on and so on. Basically the highlight is telling the user where they need to be looking and entereing their data. Like i have stated this is just not working with conditional formatting(typical way of conditionally highlighting cells), so i need some sort of code. I am a VBA newbie so if you could help me by posting some code and if i have to name a range and so on. Thanks in advance for any help.