Thread: if 3 cells have data then add certain value to another cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gerigto Gerigto is offline
external usenet poster
  
Posts: 14
Default if 3 cells have data then add certain value to another cell
I would like to make cell D1 be blacked out if cells A1, B1 and C1 have a Y
in them. How do I accomplish this? Some people may enter data into D1 first
and thus eliminate any If,then formula I enter into that cell. Is there
another way around this issue?
--
TG
Reply With QuoteReply With Quote