|
|
|
|
#1
09-11-2017, 10:33 PM
|
|||
|
|||
Referencing a cell and getting its content and colour
Hi
I have a workbook with several sheets The first sheet contains a list of participants for a rugby survey Column A is ID e.g. RG_1, RG_2, RG_3 etc. As the survey results come in I am colour-coding Column A green - survey completed, red - email bounced, etc The remaining sheets show subsets of sheet1 broken down into decades How do I reference a cell in column A sheet 1 and get both its value and colour? Thanks Bob M 
|
|
#2
09-11-2017, 11:59 PM
|
||||
|
||||
|
Is the color the result of conditional formatting?
If not, search the web, this problem has already been solved
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#4
09-12-2017, 03:39 AM
|
||||
|
||||
|
So you are doing this manually?
How many colors do you have? Would CF be applicable?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#6
09-12-2017, 11:41 PM
|
||||
|
||||
|
Perhaps post a sample sheet?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| add sum colour cell to a button | Kubi | Excel Programming | 5 | 05-17-2017 03:45 PM |
| Referencing to a cell in table | naeemakhtar | Word VBA | 1 | 06-02-2016 08:46 PM |
 Referencing + Automatic update of Shared Content in MS Word.
|
mitucool | Word | 14 | 10-09-2013 02:08 AM |
|
Quadrant colour based on cell value
|
RoyLittle0 | Excel | 2 | 05-05-2013 12:50 AM |
| CHange colour of footer if a cell changes to red | OTPM | Excel | 0 | 05-26-2011 07:15 AM |
Windows 7 32bit 
Office 2007
Hybrid Mode