Conditional Formatting Question

[livifivil]

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

 

[VBA Noob]

Say $A$1 = "Something"

then select A1 to A7 and enter this formula in Conditional formatting

=$A$1="something"

VBA Noo

 

[livifivil]

That worked!!! The problem I have now is that I need this to work fo
more than one row. I tried using the format painter but the problem i
that they all refer back to the original cell, not the cell in eac
particular row

 

[daddylonglegs]

You don't need the second $. Use this

=$A1="something"

 

[RagDyeR]

Just remove the dollar signs ($) from $A$1 (A1) *before* using the format
painter.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

message
That worked!!! The problem I have now is that I need this to work for
more than one row. I tried using the format painter but the problem is
that they all refer back to the original cell, not the cell in each
particular row.

 

[livifivil]

Perfect, THANKS!!!