PC Review


Reply
Thread Tools Rate Thread

Conditional Formating based on other cell values??

 
 
Dan B
Guest
Posts: n/a
 
      13th Nov 2003
Is there a way to apply formatting to one cell based on the conditions of
another cell? For example, if A1 is equal to 10 then format C1 to red text.

Is there any way to do that. Please let me know either way.
Thanks,

Dan


 
Reply With Quote
 
 
 
 
Debra Dalgleish
Guest
Posts: n/a
 
      13th Nov 2003
There are instructions here:

http://www.contextures.com/xlCondFormat02.html

With your example, select cell C1, and in the conditional formatting
dialog box, use the formula:
=$A1=10

Dan B wrote:
> Is there a way to apply formatting to one cell based on the conditions of
> another cell? For example, if A1 is equal to 10 then format C1 to red text.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
Reply With Quote
 
Dan B
Guest
Posts: n/a
 
      13th Nov 2003
That did it. Thanks!!


"Debra Dalgleish" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> There are instructions here:
>
> http://www.contextures.com/xlCondFormat02.html
>
> With your example, select cell C1, and in the conditional formatting
> dialog box, use the formula:
> =$A1=10
>
> Dan B wrote:
> > Is there a way to apply formatting to one cell based on the conditions

of
> > another cell? For example, if A1 is equal to 10 then format C1 to red

text.
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formating for the whole row, based on one cell value Renata Microsoft Excel Misc 2 7th Jan 2010 12:16 AM
Conditional Formating Based on Formats Instead of Values Abby Dabby Doo Microsoft Excel Misc 1 15th May 2008 01:18 AM
Re: Conditional Formating based on a different cell SteveW Microsoft Excel Misc 0 9th Dec 2006 08:57 PM
Conditional Formating based on other cell values?? Dan B Microsoft Excel Misc 2 13th Nov 2003 08:53 PM
Conditional Formating based on other cell values?? Dan B Microsoft Excel Worksheet Functions 2 13th Nov 2003 08:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:30 AM.