| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Hello Guru's
on sheet2 cell a2 I have a name derived by =sheet1!a2 on sheet2 cell d2 I have True or 0 derived by a vlookup on sheet1 If sheet 2 cell d2 shows True I would like to color in sheet2 a2 with some fill pattern Thanks for your help Bart |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formatting
Click on cell D2 on Sheet2, then Format ConditionalFormat Formula Is
=$A$2=TRUE FormatButton and set the format of choice.....OK...... Vaya con Dios, Chuck, CABGx3 "Ian Bartlett" wrote in message news:JdSBf.220175$tl.56776@pd7tw3no... Hello Guru's on sheet2 cell a2 I have a name derived by =sheet1!a2 on sheet2 cell d2 I have True or 0 derived by a vlookup on sheet1 If sheet 2 cell d2 shows True I would like to color in sheet2 a2 with some fill pattern Thanks for your help Bart |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
