| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do you format a row of cells based upon a value in another ce.
how do you format a row or a range of cells based upon a value in a cell not
included in the conditional format? |
|
#2
|
|||
|
|||
|
Hi
select the cells to have the conditional formatting on them choose format / conditional formatting choose formula is type the criteria (ie =$E$150) click the format button to apply the formatting. Cheers JulieD "hazenb1" wrote in message ... how do you format a row or a range of cells based upon a value in a cell not included in the conditional format? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cells to display truncated values? | Excel Discussion (Misc queries) | |||
| Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
| conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) | |||
Linear Mode
