Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have multiple sheets on one document. One sheet 1 there are about 390 individuals by name. On each subsequent sheet, they are grouped in different categories. Is there a way that if I fill one with color on sheet 1, it will autofill them on the other sheets?
Solved by F. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 22/08/2018 - 04:38
Welcome to ExcelChat!
User 22/08/2018 - 04:38
Thank you
Excelchat Expert 22/08/2018 - 04:39
If I got your problem right, you have the same names on different sheets
Excelchat Expert 22/08/2018 - 04:39
and you wonder whether it is possible to change their colours at once, right?
User 22/08/2018 - 04:39
Correct. And I am hoping that if I fill a cell on sheet one for a person, it will autofill the same name in a different sheet
Excelchat Expert 22/08/2018 - 04:40
So if I make A1 green on this sheet, you want Person1 to be green on sheet2 as well, right?
User 22/08/2018 - 04:40
Yes
Excelchat Expert 22/08/2018 - 04:42
Well, there is no direct way to achieve this
Excelchat Expert 22/08/2018 - 04:42
But I can try to suggest a work around
Excelchat Expert 22/08/2018 - 04:42
Do you want to highlight your cells with different colours?
User 22/08/2018 - 04:43
No, basically I am one by one over time filling cells Red to indicate "Not Available." So I was hoping I could just do it in Sheet 1 and it would fill the individual as red in the subsequent sheets so I don't have to scroll through and find them
Excelchat Expert 22/08/2018 - 04:44
how about using replacement for that purpose?
Excelchat Expert 22/08/2018 - 04:44
For example you could replace Person 1 With Person 1 (N/A)
Excelchat Expert 22/08/2018 - 04:45
and on all your sheets you can create a conditional formatting rule, which will make red names with (N/A)
Excelchat Expert 22/08/2018 - 04:45
So for example you have name Peter, and he is NA
Excelchat Expert 22/08/2018 - 04:45
You type ctrl + F, replace Peter with Peter (N/A) on all sheets
Excelchat Expert 22/08/2018 - 04:46
And on all sheets these cells will be red
Excelchat Expert 22/08/2018 - 04:46
What do you think?
Excelchat Expert 22/08/2018 - 04:46
To my mind, this is the best solution for this case

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc