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
0
Utf
3/9/2010 7:58:01 AM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
590 Views

Similar Articles

[PageSpeed] 46

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
0
Utf
3/9/2010 8:19:03 AM
See http://www.contextures.com/xlCondFormat01.html

-- 

HTH

Bob

"selvaraj" <selvaraj@discussions.microsoft.com> wrote in message 
news:48448FBF-BD3C-40E3-A6DE-0FE749B679AB@microsoft.com...
> 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 


0
Bob
3/9/2010 8:39:31 AM
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/

0
nancy0123
3/9/2010 9:11:33 AM
Reply:

Similar Artilces: