Conditional format - how can I format a cell based on a DIFFERENT cell's value?

[Shiperton Henethe]

Hi

Conditional format

Is there a way to get a cell's format determined by the format of
a different cell?!

e.g. Could one get an entire row market up in say bold red if
one cell in that row was say less than 100

With thanks


Ship
Shiperton Henethe

 

[JulieD]

Hi Shiperton

yep )
select the rows that you want to apply the conditional formatting to,
ensuring that the first row of this group is the first row at the top of the
screen (it gets confused sometimes if it isn't)
the following example assums you've selected from row 2 onwards and you want
the row to turn red if the value of F2 is less than 100

choose format / conditional formatting
choose
formula is
type
=$F2<100
click format
set your format click OK twice


Cheers
JulieD

 

[Shiperton Henethe]

Superb!
And then you can simply paint the format around at will.
I like it.

Incidentally has the (business) world come up with a rational
colouring system - e.g. Green for "go/good", Red for "stop/bad"... ?

(If so what does blue mean on a number...
And how do I visually flag, "quite good" or "neither good nor bad" etc)

TVM indeed


Ship
Shiperton Henethe