Thread: Cell formating
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default Cell formating

Put your conditional format in cells A5, A7, and A8 and use the formula
=A3<"" in each cell. HTH Otto
"Patrick C. Simonds" wrote in message
...
I had hoped to do this with Conditional Formatting, but it does not seem to
be allowed.

If cell A3 is not blank I want to change the border format on cells A5, A7
and A8 with the lines which in effect crosses out the cell.