Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2004

Tip: Looking for answers? Try searching our database.

If C30>D30,color = green?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rmpete - 05 Jul 2004 01:39 GMT
Hi,
In Excel 97, how can I arrange it so that If C30>D30,color
= green?
Thanks,
Norman Harker - 05 Jul 2004 01:54 GMT
Hi rmpete!

Use Conditional Formatting

Select C30
Format > Conditional Formatting
Cell Value Is
Greater than
=D30
Format Button
Select Format
OK
OK

Signature

Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au

CLR - 05 Jul 2004 01:55 GMT
Hi...........

I don't have 97 on my machine right now and don't remember the exact menu
items, but the feature you're looking for is called Conditional
Formatting........

Try this.........click on C30, then do Format > Conditional Formatting,
.....in the popup box, leave first window on left to say "Cell Value
Is".....in the middle window, select "greater than", and in the rightmost
window type =$D$30, then click the "Format" button, choose the patterns tab,
and select the green you want and click ok........then OK again, and you're
done.......anytime C30 is greater than D30, C30 will become green...........

Vaya con Dios,
Chuck, CABGx3

> Hi,
> In Excel 97, how can I arrange it so that If C30>D30,color
> = green?
> Thanks,
Max - 05 Jul 2004 07:41 GMT
And if you want the fill color to appear in a cell other
than C30 or D30, say in E30, you could also try ..

Select E30

Click Format > Conditional Formatting

Make the settings under Condition 1:

Formula Is | =C30>D30

Click Format button > Patterns tab > Light green? > Ok

Click OK at the main dialog

Signature

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

> Hi,
> In Excel 97, how can I arrange it so that If C30>D30,color
> = green?
> Thanks,
- 14 Jul 2004 20:24 GMT
Thanks so much to all of you.
Conditional Formatting did the job,
very well and very easily.
Thanks again,
rmpete

>-----Original Message-----
>Hi,
>In Excel 97, how can I arrange it so that If C30>D30,color
>= green?
>Thanks,
>.
Max - 14 Jul 2004 23:28 GMT
You're welcome, rmpete!
Thanks for the feedback ..
Signature

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

> Thanks so much to all of you.
> Conditional Formatting did the job,
> very well and very easily.
> Thanks again,
> rmpete
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.