| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
condition format
hi, i need conditional format, when i put cell value ' selva', i want the
entire row in red, green or some colour.. pls give the conditional format |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
condition format
assuming you want to turn row 10 red ---- click on the # 10 -- click format /
conditional format / formula is =$10:$10="selva" ---- format colour -- grizz "selvaraj" wrote: hi, i need conditional format, when i put cell value ' selva', i want the entire row in red, green or some colour.. pls give the conditional format |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
condition format
See http://www.contextures.com/xlCondFormat01.html
-- HTH Bob "selvaraj" wrote in message ... hi, i need conditional format, when i put cell value ' selva', i want the entire row in red, green or some colour.. pls give the conditional format |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
condition format
Yes you should do like this:
click format / conditional format / formula is =$10:$10="selva" ---- format colour selvaraj wrote: hi, i need conditional format, when i put cell value ' selva', i want the entire row in red, green or some colour.. pls give the conditional format -- #1 Data Recovery Services Stellar Information Systems Ltd. D18, Sector-33, Infocity Phase II, Gurgaon-122001 Phone : (0124) 326 6069, 432 6700 Website : http://www.stellarinfo.co.in/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Condition Format with 2 cell | Excel Worksheet Functions | |||
| Condition Format with value of other column | Excel Worksheet Functions | |||
| Cell format as condition | Excel Worksheet Functions | |||
| use more than 3 condition in conditional format | Excel Worksheet Functions | |||
| Condition Format | Excel Discussion (Misc queries) | |||
Hybrid Mode
