Conditional Format to change entire row based on one cells data

[Crowbar via OfficeKB.com]

Hi

Computer Value profit
AMD 301 100

At the moment If a value is more than 300 the box turns red, however, i would
like to make AMD cell and 100 cell turn ed based on this result at the same
time??


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200510/1

[Bob Umlas]

Select the row, and use the conditional format "formula is" to be (assuming
Value is in column B):
=$B2>300
then click the Format button & pattern tab & make it red.
The "$" is the key -- all cells in the selection will look at the value in
B.
Bob Umlas
Excel MVP

"Crowbar via OfficeKB.com" <u15117@uwe> wrote in message
news:565ecbc311957@uwe...
> Hi
>
> Computer Value profit
> AMD 301 100
>
> At the moment If a value is more than 300 the box turns red, however, i
would
> like to make AMD cell and 100 cell turn ed based on this result at the
same
> time??
>
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...excel/200510/1

[Bob Phillips]

Use a conditional formula of
=$B2>300

and apply to all cells in the row, select all rows and apply in one action
(assuming row 2 is the first row).

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Crowbar via OfficeKB.com" <u15117@uwe> wrote in message
news:565ecbc311957@uwe...
> Hi
>
> Computer Value profit
> AMD 301 100
>
> At the moment If a value is more than 300 the box turns red, however, i
would
> like to make AMD cell and 100 cell turn ed based on this result at the
same
> time??
>
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...excel/200510/1