Conditional Formatting Question

L

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

VBA Noob

Say $A$1 = "Something"

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

=$A$1="something"

VBA Noo
 
L

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
 
R

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.
 
Top