| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
excel: How can I color code rows based on a value in a cell?
Jexample: If the value in cell J2=P, then shade the entire row in yellow.
|
|
#2
|
|||
|
|||
|
1. Select row 2.
2. Go to Format Conditional Formatting. Select "Formula Is" 3. Insert: =$J$2="P" 4. Click the "Format" button and format as desired. HTH Jason Atlanta, GA -----Original Message----- Jexample: If the value in cell J2=P, then shade the entire row in yellow. . |
|
#3
|
|||
|
|||
|
Parker
Select the entire row to color. Doesn't have to be row 2. FormatConditional FormattingFormula is: =$J2="P" Pick a color from from the Format button. Note the $J2 must be entered as is with the $ sign. Gord Dibben Excel MVP On Tue, 1 Feb 2005 13:43:02 -0800, "Parker1333" wrote: Jexample: If the value in cell J2=P, then shade the entire row in yellow. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
| Should be able to name Excel sheets based on cells in workbook | Excel Discussion (Misc queries) | |||
| how do I show a picture in excel based on cell data | Excel Discussion (Misc queries) | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
| How do I remove blank rows in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
