| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional format a range
Stefi
You're a genius. Perfect thank you "Stefi" wrote: Select range say A1:T10 (adjust T10 as required) Formula for condition1 =$D2="completed" choose yellow Formula for condition2 =$D2<"" choose green Regards, Stefi €˛Wanna Learn€¯ ezt Ć*rta: This is what I'm trying to accomplish: when the word "completed" appears in column D I want the that ROW (lets say a1 to T1) to be highlighted in yellow,if another word appears on that cell then highlighted in green I tried conditional formatting - Cell value is - and of course it only highlights one cell. I also tried conditional formatting using" formula is" and that is where I'm having dificulties. 'm stuck... someone help me please thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy with format | New Users to Excel | |||
| Is it possible to copy a conditional format formula as paste value | Excel Discussion (Misc queries) | |||
| Conditional Format | Excel Discussion (Misc queries) | |||
| Conditional Formating. Remove condition, keep format? | Excel Discussion (Misc queries) | |||
| Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
Threaded Mode
