Thread
:
Conditional format -blank
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Posts: n/a
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
Reply With Quote