 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2007Conditional formatting - Highlighting a row
How do I tell Excel to highlight the entire row when data from two columns does not match exactly, i.e. g3 should be exactly the same as h3 but if not, highlight the entire 3rd row? Thank you. Select the range to highlight (I'm using A3:X999) With row 3 containing the activecell: Format|Conditional formatting formula is: =$H3<>$G3 and give it a nice format. The $'s will mean that columns H and G will always be used to determine the formatting for that row. With no $ in front of the 3's, excel will adjust them for each row in the selected range. > How do I tell Excel to highlight the entire row when data from two columns > does not match exactly, i.e. g3 should be exactly the same as h3 but if not, > highlight the entire 3rd row? > > Thank you.  SignatureDave Peterson Thank you for your help. I'm doing something wrong. Highlighted range. Selected Conditional Formatting button. Highlight cell rules/more rules Format only cells that contain cell value/not equal to/put in your formula selected yellow fill/ok but yellow filled in all my selected area except a column that is blank. Thank you. > Select the range to highlight (I'm using A3:X999) > With row 3 containing the activecell: [quoted text clipped - 13 lines] > > > > Thank you. You don't want "Cell value is" You need "Formula is" SignatureDavid Biddulph > Thank you for your help. > I'm doing something wrong. [quoted text clipped - 28 lines] >> > >> > Thank you. I got it! Thank you very much. Thank you all so much for your time and information! > You don't want "Cell value is" > You need "Formula is" [quoted text clipped - 30 lines] > >> > > >> > Thank you. Select all of row 3 or just the portion to highlight. Format>CF>Formula is: =$H3<>$G3 Choose a pattern from Format and OK your way out. Note the $ signs to lock the columns but not the rows in case you want to copy that format to other rows. Gord >How do I tell Excel to highlight the entire row when data from two columns >does not match exactly, i.e. g3 should be exactly the same as h3 but if not, >highlight the entire 3rd row? > >Thank you. =NOT(EXACT($A1,$B1)) > How do I tell Excel to highlight the entire row when data from two columns > does not match exactly, i.e. g3 should be exactly the same as h3 but if not, > highlight the entire 3rd row? > > Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.