View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Conditional format -blank

Select A1 and in your CF box use: Formula is and then
=ISBLANK(B1:Z1)
and set your format.

Andy.
"Simon Smith" <Simon wrote in message
...
Can't get the conditonal format function to work such that A1 is a red
font
if b1 through z1 is blank.
Just looking for an easy way to identify if theres an emply cell on a row
without scrolling.

Any ideas