Home |
Search |
Today's Posts |
#1
|
|||
|
|||
change the rows value based on conditions
hi,
please see the comment in attached sheet for clarifcation and work in 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 it 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 F4 is either Yes or Y. also i should become must to fill this cell in this case. anyideas how to acheive this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help to change a cell color based on conditions | Excel Worksheet Functions | |||
delete rows based on 2 conditions of that row | Excel Programming | |||
Hide/Show rows based on Conditions | Excel Programming | |||
Conditional Formatting of Rows Based On More Than 4 Conditions | Excel Programming | |||
Deleting rows based upon Error conditions | Excel Programming |