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

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

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
>