Conditional Formatting Question

[livifivil]

I want the formattin of a series of cells to be dependent on the data i
another cell. For instance, if A1 is a result of "something" then A1:A
will all turn red. How do I get that done?

 

[Ron Rosenfeld]

I want the formattin of a series of cells to be dependent on the data in
another cell. For instance, if A1 is a result of "something" then A1:A7
will all turn red. How do I get that done??

result of what?

In general, you would enter a conditional formula of the type:

Formula Is: =$A$1="something"

in A1:A7


--ron