View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian Bartlett
 
Posts: n/a
Default 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