View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
nancy0123 nancy0123 is offline
external usenet poster
 
Posts: 1
Default 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/