Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating - by row, not by column (Office 2007)
Hi. I have a spreadsheet with 100 rows of data. There are drop downs in
columns M-P. I want to do conditional formatting by row (not column) to highlight when cells M, N, O or P have duplicate values. I've been able to get this to work by highlighting a row of those 4 cells one at a time, hiting conditional formating - highlight duplicate values but I don't want to have to do this for every row like this. I haven't been able to figure out how to copy this down so the conditional formatting looks across only and not down for repeat values. Help would be appreciate. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating - by row, not by column (Office 2007)
One way:
Select M:P. Assuming M1 is active: CF1: Formula is =COUNTIF(OFFSET($M1,,,1,4),M1)1 In article , bp wrote: Hi. I have a spreadsheet with 100 rows of data. There are drop downs in columns M-P. I want to do conditional formatting by row (not column) to highlight when cells M, N, O or P have duplicate values. I've been able to get this to work by highlighting a row of those 4 cells one at a time, hiting conditional formating - highlight duplicate values but I don't want to have to do this for every row like this. I haven't been able to figure out how to copy this down so the conditional formatting looks across only and not down for repeat values. Help would be appreciate. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating/Excel 2007 to 2003 | Excel Discussion (Misc queries) | |||
Conditional Formating Using Office 2007 | Excel Worksheet Functions | |||
Conditional Formating in Excel 2007 | Excel Worksheet Functions | |||
Office 2007-Source formating lost when emailing from excel | Excel Discussion (Misc queries) | |||
Office 2007-Source formating lost when emailing from excel | Excel Discussion (Misc queries) |