Conditional format,Colour fill

[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

 

[Frank Kabel]

Hi

you do not need any VBA. Goto 'Format - Conditional Format'
For more infos have a look at the Excel helpfile or
http://www.cpearson.com/excel/cformatting.htm

Frank