![]() |
#1
|
|||
|
|||
![]()
Hello, I used Conditional Formatting to find values that were in column B but not column C. I now want to show these results (without the shading) of this formatting in column D. In this sample case that would be 3 items. Also, column B may vary up to 1000 different items. Is there a way to rewrite the “Applies to” in the Rules Manager to just the cells in column B that have data starting with B2? I must be using the wrong wording to explain this because I cannot find any solutions. Thank you.
|
|
![]() |
||||
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 |
![]() |
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 |