condition format

[selvaraj]

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

 

[grizzly6969]

assuming you want to turn row 10 red ---- click on the # 10 -- click format /
conditional format / formula is =$10:$10="selva" ---- format colour

 

[Bob Phillips]

See http://www.contextures.com/xlCondFormat01.html

 

[nancy0123]

Yes you should do like this:
click format /
conditional format / formula is =$10:$10="selva" ---- format colour

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/