| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
