Thread: Conditional Formatting: Referencing from a different cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default Conditional Formatting: Referencing from a different cell
Hi Becky,
Do conditional formating, position yourself in A1 then conditional
formating, where the formula is enter
A3=0
Then choose the format you want and done

"Becky" wrote:

I need to format cell A1 with strikeout if cell A3 is 0 (zero). How do I
write that?
Reply With QuoteReply With Quote