Google Sheets - Conditional Formatting
Вставка
- Опубліковано 23 сер 2024
- Learn conditional formatting fundamentals in Google Sheets. In this tutorial we'll start with basic conditional formatting, then we'll move to linking conditional formatting to a cell value and function results, and finally demonstrate how to use color scales.
#GoogleSheets #ConditionalFormatting
That trick at 5:05 about dragging to give a certain condition priority was a life saver. Thanks!
I think it's an excellent video, I'll try to translate it into Spanish to understand it better, a thousand thanks and to continue with that enormous enthusiasm that has always had in the teaching of the Google spreadsheet.
GOOD GOD MOONESH! WHAT YOU HAVE ME DOINGGGGGG
You to huh
this is crazy! this is actually insane!
Excellent video. Lot of good tips
You are amazing brother, keep it up.
👍
Well explained 👏👏👏👌👌👌Thank you so much
👍
I like your Videos.
how to protect sheet behalf of condition formatting please suggestion me
great work thanks,
Amazing!!
please help me, how to make BUTTON PRINTER script editor in google sheet? i can make program button print in excel but not for google sheet
Can I time stamp with a specific text in a cell???
Great..Thanks a lot...
A few questions can you use conditional formatting for linked data. Or Conditional importing of data or linking of data? I saw the other video on linking data between sheets.
Great video! I was wondering if you could explain how can I apply any formula to a cell that would highlight other cells related to it?
Here you go ua-cam.com/video/NhEqCqt-nl4/v-deo.html
@@ExcelGoogleSheets aye thanks man~! have a good day!
I am trying to figure out if I can do a conditional formating that will automatically change based on the value of another cell which also changes automatically. This is the cell that I want to link my conditional formating to =COUNTIF(A4:A1002,"") I have few other columns with =countif(C4:C1002,true). In column A I am adding data manually, that will change the value in the cell with the first formula for example to "100" I want to make the background of the cells with the second formula change colors from red to green when the number is closer or equal to the value in the cell with the first formula.
In every column with the second formula, there is a specific number of tasks which need to be done, that number is always changing and it is shown in the cell with the first formula
Can we lock cells based on color selected ? @Learn Google Spreadsheets
I have a Particular Project I have a Question on if I may.
Would you be able to help? I want sheets to recognize Jon in column A, take column J dollar amount, and multiply . 75 into Column O. Would you be able to put a formula for that? Thanks
🙏🏻
hi need help, how can i use arrow instead of the color scale? in excel we have the choices.
How do I use a value from another sheet in conditional formating? i.e. I'm on 'Percent' sheet, I apply conditional formatting using a value from the 'Percent Change' sheet, cell A1.
I tried using 'Percent!A1' but it doesn't seem to work. Thanks
Example here ua-cam.com/video/NhEqCqt-nl4/v-deo.html
Danke!
I appreciate it!
@@ExcelGoogleSheets DESERVED!
Is it possible to do this with multiples of certain numbers?
ex. finding and formatting all multiples of two and changing their color.
Yes, use formula to do conditional formatting. Watch the advanced video.
@@ExcelGoogleSheets Thank you
It only highlights the particular cell, what if I wanted to highlight the entire row
Lets say I want a1 to turn black if b1 goes to 0 or below 0