Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cond form formula
Assuming the dropdown is from the Data=Validation or each dropdown is
linked to the cell in column B of that row - in any event, the end result is the cell in column B of that row will hold the value "done" without quotes. select the cells with A1:C4 with A1 as the activecell do Format=Conditional Formatting change "Cell is" to "Formula is" by selecting in the first dropdown put in the formula =$B1="done" then select format button, pattern and select red. OK out of the dialogs. Regards, Tom Ogilvy "Paul" wrote in message ... Easy one I'm sure but can't get it right: I have a table (A1:C4) with a drop down list on each cell of my B colum. When I select "Done" from my drop down in B, i would like that the appropriate line becomes red. I've tried if b2=''done'' (and formatting the way I want it) but it does'nt work. Help me! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIND LETTER IN CELL (cond. form mult entries not wrking) | Excel Discussion (Misc queries) | |||
Cond Formula for adding only cells of particular colour | Excel Worksheet Functions | |||
Make the result of a formula red (cannot be done in cond. format.) | Excel Discussion (Misc queries) | |||
how to use * wildcard in a sum(if((cond),range)) array formula | Excel Worksheet Functions | |||
Cond form formula | Excel Programming |