Using Excel in Office 365 I wish to highlight names t... HiDBrydon Not sure this will work because you don't disclose the Conditional Formatting rule that Applies to Q32:Q81 to highligh Subtotals in green Edit that Conditional Formatting rule. It currentlyApplies to: $Q$32:...
Share Resources
Tip.In some rare cases, mostly on very large workbooks, the above shortcuts may select both visible and invisible cells. To fix this, press eitherCtrl + AorCtrl + Shift + Endfirst, and then pressAlt + ;toselect only visible cells, ignoring hidden rows. If you have difficulties with reme...
{"__ref":"Forum:board:ExcelGeneral"},"subject":"Re: Find and highlight numerical values one column based on a column of numbers in another worksheet.","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:3288657"},"parent":{"__...
Microsoft Support Community