Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
Hello,
Using Excel 2007, I want cells in a column to be formatted according to cells in a different column and I want it to work so that if A1="text", B1 gets formatted; if A2="text" (same text), B2 gets formatted, etc... I use the formula A:A="text" applied to B:B and even $A:$A="text" applied to $B:$B, but neither work. It only works for one cell at a time (if I apply the formula to B1 using A1). My column is rather big, I do not want to repeat the formula all the way down, there's gotta be a way :) Any help would be appreciated, thanks. Caroline |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
Hi,
2007: 1. Select B1:B1000 or what ever (note the active cell is B1, meaning you select from B1) 2. Choose Home, Conditional Formatting, New Rule 3. Pick Use a formula to determine which cells to format 4. In the Format values where this formula is true, enter the formula: =A1="text" 5. Click the Format button and on the Fill tab choose a color 6. Click OK twice. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Caroline" wrote: Hello, Using Excel 2007, I want cells in a column to be formatted according to cells in a different column and I want it to work so that if A1="text", B1 gets formatted; if A2="text" (same text), B2 gets formatted, etc... I use the formula A:A="text" applied to B:B and even $A:$A="text" applied to $B:$B, but neither work. It only works for one cell at a time (if I apply the formula to B1 using A1). My column is rather big, I do not want to repeat the formula all the way down, there's gotta be a way :) Any help would be appreciated, thanks. Caroline |
Reply |
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 |