Conditional Formatting For A Cell Other Than The One With The Form

[Guest]

I know how to conditionally format based on the value within a cell.
Unfortunately, the formatting only affects the cell that is the subject of
the condition. In other words,the formatting of Cell A1 is conditional on
the value of Cell A1.
But is it possible to format cell B1 based on the value in cell A1? For
example, if the value of Cell A1 is >= 100, then I would like Cell B1 to show
a format of a red background (just a random example).
Thanks in advance!

 

[Guest]

Yes, this is possible.

Put this in the conditional format of cell B1:
=$A$1>=100
Ensure that when you do so condition 1 says "Formula Is" and not "Cell Value
Is".

 

[David McRitchie]

assuming that you would want to format the entire column or more than just
one cell in column B think you would want to use
=$A1>=100
and formatting an entire column wither cell formats or conditional formatting
should be more efficient than formatting a lot of cells individually.

More on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm
--