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

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

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

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/