highlighting cell in formula

[bamaisgreat]

Is there a formula that could say

=If A3 CONTAINS THE SAME INFO AS A7 THEN TENT OR FILL A3

FORMULA BEING IN A3. thanks

 

[T. Valko]

Is there a formula that could say

=If A3 CONTAINS THE SAME INFO AS A7 THEN TENT OR FILL A3

FORMULA BEING IN A3. thanks

You can do that with conditional formatting.

What version of Excel are you using?

 

[Weaver]

What's tent?

You ought to be able to shade a given cell using conditional formatting.

 

[p45cal]

Conditional formatting in A3, FormulaIs: (or Use Formula?):
=A3=A7

 

[Tmoske]

Try using Conditional Formatting

Select "New Rule/Format only cells that contain/Cell Value is Equal To/=A7"

Select the format.

Hope this helps.

-Tmoske

 

[bamaisgreat]

I am building the sheet in 2010 but it will be used in 2003. thanks

 

[bamaisgreat]

thanks for the help\