| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apply Conditional Formatting If Data in More Than 1 Cell Matches
I have 2 cells that contain data. The data in both these cells will be
compared against one another. If the data between the 2 cells MATCH, then turn both cells green. If the data between the 2 cells DIFFER, then turn both cells red. For example: If cell L14 matches cell F14, then turn F14 green If cell L14 does not match cell F14, then turn F14 red Do I need to use an "IF" statement combined with conditional formatting to achieve this? What would the formula look like? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Apply Conditional Formatting If Data in More Than 1 Cell Matches
You're description doesn't match.
* added for emphasis. If the... 2 cells MATCH, then turn *both* cells green. If the... 2 cells DIFFER, then turn *both* cells red. If cell L14 matches cell F14, then turn *F14* green If cell L14 does not match cell F14, then turn *F14* red -- Biff Microsoft Excel MVP "Maureen" wrote in message ... I have 2 cells that contain data. The data in both these cells will be compared against one another. If the data between the 2 cells MATCH, then turn both cells green. If the data between the 2 cells DIFFER, then turn both cells red. For example: If cell L14 matches cell F14, then turn F14 green If cell L14 does not match cell F14, then turn F14 red Do I need to use an "IF" statement combined with conditional formatting to achieve this? What would the formula look like? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Apply Conditional Formatting If Data in More Than 1 Cell Match
Let me clarify:
If the 2 cells match, I want both cells to turn green If the 2 cells do not math, I want both cells to turn red Updated example: If L14 matches F14; turn L14 and F14 green. If L14 does not match F14; turn L14 and F14 red. I am not sure how to write the formula to apply the conditional formatting. "T. Valko" wrote: You're description doesn't match. * added for emphasis. If the... 2 cells MATCH, then turn *both* cells green. If the... 2 cells DIFFER, then turn *both* cells red. If cell L14 matches cell F14, then turn *F14* green If cell L14 does not match cell F14, then turn *F14* red -- Biff Microsoft Excel MVP "Maureen" wrote in message ... I have 2 cells that contain data. The data in both these cells will be compared against one another. If the data between the 2 cells MATCH, then turn both cells green. If the data between the 2 cells DIFFER, then turn both cells red. For example: If cell L14 matches cell F14, then turn F14 green If cell L14 does not match cell F14, then turn F14 red Do I need to use an "IF" statement combined with conditional formatting to achieve this? What would the formula look like? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Apply Conditional Formatting If Data in More Than 1 Cell Match
Try this...
I don't know if need you to take empty/blank cells into account. If both cells are empty/blank they will match. So, I'll write the formulas to account for empty/blank cells. This means no format will be applied unless both cells contain some entry. Select cells F14 and L14 Goto the menu FormatConditional Formatting Condition 1 = GREEN Select the Formula Is option =AND($F14<"",$L14<"",$F14=$L14) Click the Format button Select the Patterns tab Select a nice shade of GREEN OK Click the Add button Condition 2 = RED Select the Formula Is option =AND($F14<"",$L14<"",$F14<$L14) Click the Format button Select the Patterns tab Select a nice shade of RED OK out -- Biff Microsoft Excel MVP "Maureen" wrote in message ... Let me clarify: If the 2 cells match, I want both cells to turn green If the 2 cells do not math, I want both cells to turn red Updated example: If L14 matches F14; turn L14 and F14 green. If L14 does not match F14; turn L14 and F14 red. I am not sure how to write the formula to apply the conditional formatting. "T. Valko" wrote: You're description doesn't match. * added for emphasis. If the... 2 cells MATCH, then turn *both* cells green. If the... 2 cells DIFFER, then turn *both* cells red. If cell L14 matches cell F14, then turn *F14* green If cell L14 does not match cell F14, then turn *F14* red -- Biff Microsoft Excel MVP "Maureen" wrote in message ... I have 2 cells that contain data. The data in both these cells will be compared against one another. If the data between the 2 cells MATCH, then turn both cells green. If the data between the 2 cells DIFFER, then turn both cells red. For example: If cell L14 matches cell F14, then turn F14 green If cell L14 does not match cell F14, then turn F14 red Do I need to use an "IF" statement combined with conditional formatting to achieve this? What would the formula look like? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Apply Conditional Formatting If Data in More Than 1 Cell Match
That worked great!
Thanks "T. Valko" wrote: Try this... I don't know if need you to take empty/blank cells into account. If both cells are empty/blank they will match. So, I'll write the formulas to account for empty/blank cells. This means no format will be applied unless both cells contain some entry. Select cells F14 and L14 Goto the menu FormatConditional Formatting Condition 1 = GREEN Select the Formula Is option =AND($F14<"",$L14<"",$F14=$L14) Click the Format button Select the Patterns tab Select a nice shade of GREEN OK Click the Add button Condition 2 = RED Select the Formula Is option =AND($F14<"",$L14<"",$F14<$L14) Click the Format button Select the Patterns tab Select a nice shade of RED OK out -- Biff Microsoft Excel MVP "Maureen" wrote in message ... Let me clarify: If the 2 cells match, I want both cells to turn green If the 2 cells do not math, I want both cells to turn red Updated example: If L14 matches F14; turn L14 and F14 green. If L14 does not match F14; turn L14 and F14 red. I am not sure how to write the formula to apply the conditional formatting. "T. Valko" wrote: You're description doesn't match. * added for emphasis. If the... 2 cells MATCH, then turn *both* cells green. If the... 2 cells DIFFER, then turn *both* cells red. If cell L14 matches cell F14, then turn *F14* green If cell L14 does not match cell F14, then turn *F14* red -- Biff Microsoft Excel MVP "Maureen" wrote in message ... I have 2 cells that contain data. The data in both these cells will be compared against one another. If the data between the 2 cells MATCH, then turn both cells green. If the data between the 2 cells DIFFER, then turn both cells red. For example: If cell L14 matches cell F14, then turn F14 green If cell L14 does not match cell F14, then turn F14 red Do I need to use an "IF" statement combined with conditional formatting to achieve this? What would the formula look like? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Apply Conditional Formatting If Data in More Than 1 Cell Match
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Maureen" wrote in message ... That worked great! Thanks "T. Valko" wrote: Try this... I don't know if need you to take empty/blank cells into account. If both cells are empty/blank they will match. So, I'll write the formulas to account for empty/blank cells. This means no format will be applied unless both cells contain some entry. Select cells F14 and L14 Goto the menu FormatConditional Formatting Condition 1 = GREEN Select the Formula Is option =AND($F14<"",$L14<"",$F14=$L14) Click the Format button Select the Patterns tab Select a nice shade of GREEN OK Click the Add button Condition 2 = RED Select the Formula Is option =AND($F14<"",$L14<"",$F14<$L14) Click the Format button Select the Patterns tab Select a nice shade of RED OK out -- Biff Microsoft Excel MVP "Maureen" wrote in message ... Let me clarify: If the 2 cells match, I want both cells to turn green If the 2 cells do not math, I want both cells to turn red Updated example: If L14 matches F14; turn L14 and F14 green. If L14 does not match F14; turn L14 and F14 red. I am not sure how to write the formula to apply the conditional formatting. "T. Valko" wrote: You're description doesn't match. * added for emphasis. If the... 2 cells MATCH, then turn *both* cells green. If the... 2 cells DIFFER, then turn *both* cells red. If cell L14 matches cell F14, then turn *F14* green If cell L14 does not match cell F14, then turn *F14* red -- Biff Microsoft Excel MVP "Maureen" wrote in message ... I have 2 cells that contain data. The data in both these cells will be compared against one another. If the data between the 2 cells MATCH, then turn both cells green. If the data between the 2 cells DIFFER, then turn both cells red. For example: If cell L14 matches cell F14, then turn F14 green If cell L14 does not match cell F14, then turn F14 red Do I need to use an "IF" statement combined with conditional formatting to achieve this? What would the formula look like? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Apply conditional formatting to individual cell Excel 2007 | Excel Worksheet Functions | |||
| How do I apply conditional formatting to even or odd numbers? | Excel Discussion (Misc queries) | |||
| How do I apply conditional formatting? | Excel Worksheet Functions | |||
| apply conditional formatting to negative cell values | Excel Discussion (Misc queries) | |||
| Can I Apply Conditional Formatting to a Chart? | Charts and Charting in Excel | |||
Linear Mode
