Conditional Formatting: Referencing from a different cell

  • Thread starter Thread starter Becky
  • Start date Start date
B

Becky

I need to format cell A1 with strikeout if cell A3 is 0 (zero). How do I
write that?
 
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
 
That works beautifully, but I want to apply this conditional formatting to
the whole column (over 600 rows big). How do I do that?
 
Format-Conditional format of A1
Formula is:
=A3=0
Change format to strikeout
 
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
 
Thank you, Fred. That didn't work either, but I learned something new today
- the right click & drag.
 
Sorry to hear that. If you need further help, let us know what "didn't work"
means.

Regards,
Fred.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of columns using Conditional Formatting 3
Apply Conditional Formatting to other rows 6
Conditional Formatting 1
Unable to obtain relative reference using conditional formatting 2
Conditional Formatting 1
Conditional Formatting Help 1
Conditional Format - using 3 different cells conditions together 4
Can conditional formatting be used where ..... 2

Back
Top