Тёмный

Conditional Formatting Based on Another Cells Values - Google Sheets 

Ashley N Cameron
Подписаться 32 тыс.
Просмотров 159 тыс.
50% 1

Learn how to conditionally format cells and/or rows of data from another range of cells to make a more visual impact.
#GoogleSheets #ConditionalFormatting #Data

Хобби

Опубликовано:

 

17 янв 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 50   
@Vinay6
@Vinay6 7 месяцев назад
Excellent video. It helped me with the Conditional Formatting of odd-even rows. I was trying/struggling for past 15 minutes. Thank you so much Ashley!
@DivineLightProductions
@DivineLightProductions Год назад
This was the perfect walkthrough I needed to help me understand how to get the entire row to operate with conditional formatting !! Thanks a ton! - Jared
@DivineLightProductions
@DivineLightProductions Год назад
Alright I think I spoke to soon! Lol… maybe someone can help…? I have a Google Form that is linked to a spreadsheet. I’m trying to add another column to help me manually select/track the progress/status of data that comes into the Sheet from the Form. In that status column I have “Complete” as a drop-down menu item, and I’m trying to make the entire row have conditional highlighting. But this method you teach in this video isn’t working for me… :( Do you know why that might be…? The only thing I can think of is that it won’t work with a sheet that is linked to a Form where data is automatically recorded to…?
@nomoretenpins
@nomoretenpins Год назад
Exactly what I was looking for! Thank you for sharing!
@herbb52
@herbb52 Год назад
Thanks! The Google instructions were unclear, but this helped me a lot.
@prithishyar9254
@prithishyar9254 9 месяцев назад
Exactly what I was looking for! Thanks so much!! :)
@michaelfournie6174
@michaelfournie6174 Год назад
Exactly what I needed. Thanks!
@davidbazinet8503
@davidbazinet8503 Год назад
exactly what i needed! thank you
@KT-ew8dt
@KT-ew8dt 2 месяца назад
Ty for making this simple and easy with the formula and single cell or entire cell formatting.
@akash.verma-jsji828
@akash.verma-jsji828 11 месяцев назад
Exactly what I needed thanks for the information 😊
@adeelakhter6203
@adeelakhter6203 7 месяцев назад
Easy peasy, really helped me in the very simple style
@FarazHanifMama
@FarazHanifMama 11 месяцев назад
Exactly what I needed!!
@CandiRayne16
@CandiRayne16 6 месяцев назад
This actually WORKED!!!
@VishalKansagra
@VishalKansagra 2 года назад
Thank you for sharing this, it is very helpful.
@averagedudeusa9722
@averagedudeusa9722 4 месяца назад
thanks a million! I was able to take that info and apply it to a similar, but different scenario and it works!
@dersanke396
@dersanke396 11 месяцев назад
Hey, is it possible to color a cell if the cell next to it containts a specific letter? Im trying to get a good layout and would like to see if "A" is next to "B" and so on
@PulseTriangle
@PulseTriangle 2 года назад
Thanks for the video!
@sajjadabouei6721
@sajjadabouei6721 11 месяцев назад
straight forward, to the point
@mochannel2482
@mochannel2482 7 месяцев назад
Thank you for this tutorial 👍
@tim-duncan2137
@tim-duncan2137 9 месяцев назад
Thank you Ms Cameron!
@mahbubju
@mahbubju Год назад
Heartiest thanks .
@shraddhasingh2178
@shraddhasingh2178 Месяц назад
Thanks for the tutorial..it's very helpfull
@vishalvishal1980
@vishalvishal1980 7 месяцев назад
Very Helpful, Thanks
@WajidAli-nk4lx
@WajidAli-nk4lx 21 день назад
Thank you so much. I want to add these completed projected to another list or want to count their value to specific cell what should I do?
@pallavpurohit6892
@pallavpurohit6892 Год назад
Was of help, thank you.
@FarazHanifMama
@FarazHanifMama 11 месяцев назад
Very helpful!
@marksibert305
@marksibert305 25 дней назад
Wish I saw this last year, but now I know.
@rakibmumin
@rakibmumin Год назад
Thanks a lot. .Thats helps.
@shikharkaul5587
@shikharkaul5587 Год назад
is there a way to do it based on qualitative factors of another cell? like if another cell is bolded make this one too, or if another cell is green, make this one red etc
@FATCSWALAINDIA
@FATCSWALAINDIA Год назад
Thank you so much mam ❤️
@user-lq5rb1fi6v
@user-lq5rb1fi6v 6 месяцев назад
Brilliant!
@Jay91Byrd
@Jay91Byrd 2 месяца назад
Are you able to conditional format the boarders also in google sheets?
@marksibert305
@marksibert305 25 дней назад
Hi. I wonder how you can have an open set of fields that you want to be flexible with, and change the individual cell's format, but a group of fields that will individually change to those formats when you put in just the word? To explain my self. I have a list that could say and formatted -- unassigned - white field, regular black text start - white field, bold black text in progress - blue field, bold yellow text 80% complete - green field, bold yellow text etc... and the list grid will have the single fields change to those when I just enter the word. but I also want to add a differenct word and format whenever I want, that will change in the grid's individual field too.
@dodoagung4439
@dodoagung4439 3 месяца назад
Thank you, hello miss, may I ask. How do you format conditions on different sheets
@shabbirhussain6367
@shabbirhussain6367 8 месяцев назад
VERY HELPFULL
@stellacrosti9743
@stellacrosti9743 Год назад
Thank you
@ASHISHPANDIT1234
@ASHISHPANDIT1234 Год назад
This does not work in my case, I have a description in column A, I have column X value derived from countif function, which ranges between 1 to 7, I want colour of cell in column A changes when column X value reaches to 7. This formula described in video does not work for my google sheet
@RobiSaefudin
@RobiSaefudin 14 дней назад
I wonder how to make each of the world name have different colour? Is it a formula or you do it manually?
@firdausasas7539
@firdausasas7539 5 месяцев назад
Hey I have a question. What if the cell says "Sunday" but it's actually a date that I format to display days
@WenSaiPanther
@WenSaiPanther 6 дней назад
Hi. My goal is to find a way to copy a cell and text color to copy the origination of a cell's and text's colors. For example, cell a2 has the word "completed" and the text is bold red with the cell's color purple. When I type "completed" in cell c35, it automatically makes that cell's color purple, and the word becomes bold and red. How can I do that without a script?
@john1802
@john1802 7 месяцев назад
Great tutorial. Thank you very much
@darjinc
@darjinc 10 месяцев назад
what if i want the row to change color only if a certain column is not empty. Foe example, I want 1) If column a3:a is not empty, the color should change to green 2) if column AH3:AH contains any date (not certain date), or is just not blank, color should change to red
@ZhaoYun-te4xb
@ZhaoYun-te4xb 5 месяцев назад
Hey. What if the cell that we refer to is a formula but we want the value?
@amanraj2105
@amanraj2105 Год назад
Thanku ❤
@dormarzini
@dormarzini 7 месяцев назад
i have a question: i want that the formula will take value from a cell. how can i do it?
@tonia9388
@tonia9388 2 года назад
I have a question, "for example if A is 8 , B is 10", how to colour Cell A if Cell B is bigger than Cell A? thanks
@lyndongarza3485
@lyndongarza3485 Год назад
using A2 as cell A and B2 as cell B, it would be "=B2>A2" for the formula
@aryaalizadeh
@aryaalizadeh 8 месяцев назад
👏
@plantday4680
@plantday4680 Месяц назад
Not working for me. Equal sogns result in red amd wont go away.
@GauriSingh-fj1uh
@GauriSingh-fj1uh Год назад
Please use mic for more sound
Далее
Google Sheets Formulas Tutorial
23:25
Просмотров 365 тыс.
Телеграмм-Колян Карелия
00:14
Просмотров 214 тыс.
Stray Kids <ATE> Mashup Video
02:17
Просмотров 1,7 млн
ХЕРЕЙД БОИТСЯ МОЕЙ СОБАКИ!
37:08
Advanced Conditional Formatting in Google Sheets
38:51
Conditional Formatting in Excel Tutorial
6:43
Просмотров 595 тыс.
Sum Values based on Other Cells | Google Sheets
8:21
Просмотров 3,9 тыс.
тг: @keyneceee  #корея #корейцы
1:01
Просмотров 2,8 млн
УДИВИЛА МЛАДШУЮ СЕСТРУ
0:50
Просмотров 5 млн