View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
alarson01 alarson01 is offline
external usenet poster
 
Posts: 5
Default Conditional Formatting

I want to apply conditional formatting to cells that are blank depending on
if other cells have text or numbers in them. For example:

If cells A1:A5 have text or numbers in them than cells D1:D5 must have
something in them. If they do not, then whatever cells in the range D1:D5
are blank, apply formatting.

Clear as mud? Thank you much!!
--
-A