O
o_donnell_kevin
I need to have a column which is user input with two choices:Yes or No.
In each cell down that column, to the end of the sheet. The "yes"
requires do nothing while the "No" requires that cell and all cells to
the right of it in the same row to be colour filled to the end of the
sheet with the condition that all the cells other than the one
containing "No"will colour fill only if blank.
My visual basic skill is zero that is why I am trying to implement it
using defined functions within Excel
In each cell down that column, to the end of the sheet. The "yes"
requires do nothing while the "No" requires that cell and all cells to
the right of it in the same row to be colour filled to the end of the
sheet with the condition that all the cells other than the one
containing "No"will colour fill only if blank.
My visual basic skill is zero that is why I am trying to implement it
using defined functions within Excel