Conditional Formatting results in another column

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Formatting results in another column

FAQ

Mark Forums Read

Thread Tools

Display Modes

10-26-2020, 11:11 PM

Purfleet

Windows 10 Conditional Formatting results in another column

Office 2019

Expert

Join Date: Jun 2020

Location: Essex

Posts: 345

You can do it with a rather long formula

=IFERROR(INDEX($B$2:$B$12,AGGREGATE(15,6,(ROW(B$2: B$12)-ROW($B$2)+1)/ISNA(MATCH($B$2:$B$12,$C$2:$C$12,0)),ROWS($D$2

2) )),"")

Attached Files

Book11_Purfleet.xlsm (19.8 KB, 9 views)

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to run colour conditional formatting in just column, not whole table	KateWord	Word VBA	2	09-12-2019 05:30 AM
Conditional Formatting that highlights cells when there was a change in another column	Marcia	Excel	4	04-28-2019 07:34 AM
How to fill a cell at row and column intersection with conditional Formatting	Iraj	Excel	10	12-02-2017 09:54 AM
Conditional Formatting a column	Washbue1	Excel	3	01-27-2017 01:11 PM
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N	mikey386	Excel	2	12-11-2014 01:14 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:02 PM.