Use a conditional formula of
=$B2300
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