Conditional Format to change entire row based on one cells data
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 |
Conditional Format to change entire row based on one cells data
Select the row, and use the conditional format "formula is" to be (assuming
Value is in column B): =$B2300 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 |
Conditional Format to change entire row based on one cells data
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 |
All times are GMT +1. The time now is 04:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com