View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Conditional Formatting: Referencing from a different cell

Sorry to hear that. If you need further help, let us know what "didn't work"
means.

Regards,
Fred.

"Becky" wrote in message
...
Thank you, Fred. That didn't work either, but I learned something new
today
- the right click & drag.

"Fred Smith" wrote:

Conditional formatting is a format like bold, italics, etc. So just copy
it
(right drag the cell, on release choose Fill Formatting Only).

Before you do this, you probably want to change your formula to:
=$A$3=0

Regards,
Fred

"Becky" wrote in message
...
That works beautifully, but I want to apply this conditional formatting
to
the whole column (over 600 rows big). How do I do that?

"Eduardo" wrote:

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?