|
|
#7
03-06-2020, 11:10 PM
|
||||
|
||||
Yes Karen. A2:F2 could be highlighted with yellow through conditional formatting. Select A2:F2, in the ribbon of the Home tab, open Conditonal Formatting>Formula>type this formula in the box:
=($F2,"Yes") Click Format>Fill>select yellow color>ok Again, this is a cellphone so I am not sure if the formula works okay. Edit: The formula should be: =($F2="Yes") Last edited by Marcia; 03-07-2020 at 07:00 AM. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Loop through cells and return only unique values
|
trevorc | Excel Programming | 4 | 10-11-2018 03:49 PM |
|
Sorting cells with duplicates values
|
allex011 | Excel | 4 | 12-27-2017 12:31 PM |
|
Finding Duplicates with Multiple Criteria
|
balajigade | Excel | 2 | 12-06-2015 10:16 PM |
|
Combining Records of two sheets with Loop till Unique ID
|
abhilashv | Mail Merge | 1 | 01-22-2014 04:02 AM |
| If two geographical data match in two sheets, copy unique id/code found in one sheet | alliage | Excel | 1 | 09-01-2011 05:23 AM |
Windows 7 32bit 
Office 2013
Threaded Mode