View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Graham Haughs
 
Posts: n/a
Default Conditional Format

Is it possible to set a conditional format in a cell which has a formula
so that when a value appears in that cell, the cell background changes
colour. When there is no value the default colour should remain as the
formula returns a "blank" value. When I try it the conditional format
assumes the formula is a value and shows a colour.
Value any assistance.

Graham
Turriff, Scotland