| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW CAN I APPLY A COLOR TO ENTIRE ROW USING CONDITIONAL FORMATT
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW CAN I APPLY A COLOR TO ENTIRE ROW USING CONDITIONAL FORMATT
hi, Not a good idea to highlight all the row unless you have data. If you did then select row 1 go to Data conditional formatting and enter =$A1<"" This will highlight the whole row if there is a entry. Always enter as $ to make it work VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=566386 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW CAN I APPLY A COLOR TO ENTIRE ROW USING CONDITIONAL FORMATT
Since you have elected to provide absolutely no details a guess is all you can
expect. Select the entire row. FormatCFFormula is: =$A$1="hoohah" Pick a color from FormatPatterns and Ok Gord Dibben MS Excel MVP On Sun, 30 Jul 2006 04:11:01 -0700, conditional format <conditional wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional hiding of entire rows | Excel Worksheet Functions | |||
| Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
| EXCEL 2003: Apply Conditional Formatting to COLUMNS | Excel Worksheet Functions | |||
| how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
| How to apply conditional formatting with incremental address for . | Excel Worksheet Functions | |||
Hybrid Mode
