Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cond form formula
Paul,
Select all of the cells which you would like to turn red (hold shift or control and click). Go "Format" - "Conditional Formatting". Where it says "Cell Value Is" choose "Formula Is" in the field type [=$B$2 = "Done"] without brackets. Choose your formatting and click OK Dan E "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 | |||
Can I apply Cond. Formatting to a Formula result? | Excel Worksheet Functions |