Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting: Referencing from a different cell
I need to format cell A1 with strikeout if cell A3 is 0 (zero). How do I
write that? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting: Referencing from a different cell
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting: Referencing from a different cell
Format-Conditional format of A1
Formula is: =A3=0 Change format to strikeout -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Becky" wrote: I need to format cell A1 with strikeout if cell A3 is 0 (zero). How do I write that? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting: Referencing from a different cell
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting: Referencing from a different cell
Either select the whole column before you apply the CF condition, or use
format painter. -- David Biddulph Becky wrote: 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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting: Referencing from a different cell
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? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting: Referencing from a different cell
You'd want to change to =$A$3=0 (or =A$3=0) if all 600 rows are to be
formatted based on the content of A3. If the format of A1 is to be based on A3, and each cell's format is to based on the format of the cell 2 rows down, it stays as =A3=0. -- David Biddulph 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? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting-Referencing adjacent cell | Excel Discussion (Misc queries) | |||
Conditional formatting referencing date of expiration | Excel Worksheet Functions | |||
Cell referencing for condtional formatting | Excel Discussion (Misc queries) | |||
Retaining date formatting in referencing cell | Excel Discussion (Misc queries) | |||
Cell Referencing problem when copying conditional formatting | Excel Discussion (Misc queries) |