Conditional Formating based on other cell values??

[Dan B]

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

 

[Debra Dalgleish]

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]

That did it. Thanks!!

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

text.