| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Conditional Formating for a cell based on another cell's value | Excel Discussion (Misc queries) | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Conditional Format based on contents of cell. | Excel Worksheet Functions | |||
| How do I use conditional formatting to change subtotals row format | Excel Worksheet Functions | |||
Linear Mode
