Conditional Formatting
I am trying to set up conditional formatting on an existing Excel worksheet
that has information in cells B1:F1 to B203:F203. What I want to happen is that when I type "ok" in a cell in column A [i.e. A1], the text in columns B to F [B1:F1] should Strike Through. I was successful in setting this up on one row. Keeping in mind that the format is set up on the cells that already contain text, how do I copy the format to all the other rows without doing it one by one? |
Conditional Formatting
I find that the easiest way to set up conditional formatting is to select the
entire range that the conditional formatting is to apply to and then insert the condition as if it applies to the first cell in the selection only (that is the cell that is still white). Excel then looks after applying the condition to the remaining cells. You do have to consider whether to use any absolute addressing in the condition and you do this by applying the same rules when entering any formula in a cell and you need to consider whether absolute, partial absolute or relative addressing is required if you are going to copy the formula to other cells. Alternatively you can select the cell with the format and Copy then select the entire range to be conditionally formatted (including the one copied) and Paste Special - Formats. -- Regards, OssieMac "Mags" wrote: I am trying to set up conditional formatting on an existing Excel worksheet that has information in cells B1:F1 to B203:F203. What I want to happen is that when I type "ok" in a cell in column A [i.e. A1], the text in columns B to F [B1:F1] should Strike Through. I was successful in setting this up on one row. Keeping in mind that the format is set up on the cells that already contain text, how do I copy the format to all the other rows without doing it one by one? |
All times are GMT +1. The time now is 08:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com