| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I format a row based on the contents of one cell?
For example: I have a table of data that contains the column 'status'. If
the contents of the 'status' cell is COMPLETE, I want to change the color format of the row (i.e. make it grey). |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I format a row based on the contents of one cell?
Yes, use conditional formatting, select the whole row and use a formula of
=$A1="COMPLETE" -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Kirsty" wrote in message ... For example: I have a table of data that contains the column 'status'. If the contents of the 'status' cell is COMPLETE, I want to change the color format of the row (i.e. make it grey). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| Showing the contents of a cell based on another cell | Excel Worksheet Functions | |||
| New column based on row cell format | Excel Discussion (Misc queries) | |||
| Cell contents with custom time format rounded after double-click | Excel Discussion (Misc queries) | |||
| Format text in one cell based on value in another cell | Excel Worksheet Functions | |||
Linear Mode
