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