change the rows value based on conditions

U

Umesh Banga

hi,

please see the comment in attached sheet for clarifcation and work i
progress.

my question in comment is

how can I change this formula to do the following:

1) if the value is not anything except "Y","y", "n","N", or blank i
should through a warning message. Is using list box is alternative.

2) I want this cell to actually change color if the value of the cell F
is either Yes or Y. also i should become must to fill this cell in thi
case.

anyideas how to acheive this

+-------------------------------------------------------------------
|Filename: Checklist.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=387
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complicated Match Formula with conditions 2
how to append a phrase to a cellcontent 4
countif with some conditions 7
Change the colour of a neighbouring cell 6
how to link ranges into transpose style? 0
After Copy Past shows Error. (#VALUE!) 2
Help with Look Up with multiple complex conditions 2
Formula to calculate commission based on sliding scale 2

Top