Conditional Formatting

I

Ian Bartlett

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
 
C

CLR

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
 
I

Ian Bartlett

Many thanks that did the trick

CLR said:
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
Click to expand...
 
Top