Conditional Formatting Question

L

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?
 
R

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??
Click to expand...

result of what?

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

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

in A1:A7


--ron
 
Top