| 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? |
| 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 | |||
Threaded Mode
