| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting
I need a formula that will highlight an entire row when the value of one cell
is true - anyone know how?? -- hoggma |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting
Suppose you want to hightlight the row if Cell in Col A contains TRUE
1. Select the rows you want to hightlight 2. Choose conditional formatting 3. Choose FORMULA IS 4. Enter the formula =$A1=TRUE (assuming first row in selection is row 1 otherwise change one to that row) 5. Choose the format you want 6. Click Apply/Ok and you are done "hoggma" wrote: I need a formula that will highlight an entire row when the value of one cell is true - anyone know how?? -- hoggma |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting
You do it with conditional formatting. If you can tell us which cell
(column) you are looking at we can give you exact instructions on how to do it. Hope this helps. Pete On Jan 7, 5:21*pm, hoggma wrote: I need a formula that will highlight an entire row when the value of one cell is true - anyone know how?? -- hoggma |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
