Google Sheets - Conditional Formatting

[@muragepeter]

That trick at 5:05 about dragging to give a certain condition priority was a life saver. Thanks!

[@PaulTheLegend13]

Danke!

[@ExcelGoogleSheets]

I appreciate it!

[@PaulTheLegend13]

@@ExcelGoogleSheets DESERVED!

[@santosahernandezmendoza7147]

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.

[@legendarymudkip6968]

this is crazy! this is actually insane!

[@maheshkumarmandal2478]

how to protect sheet behalf of condition formatting please suggestion me

[@psr8230]

Well explained 👏👏👏👌👌👌Thank you so much

[@ExcelGoogleSheets]

👍

[@Valmikii]

GOOD GOD MOONESH! WHAT YOU HAVE ME DOINGGGGGG

[@left4bread599]

You to huh

[@share_feelings5366]

You are amazing brother, keep it up.

[@ExcelGoogleSheets]

👍

[@DhruvDua88]

Excellent video. Lot of good tips

[@esaismael7406]

great work thanks,

[@troyperez8454]

Can I time stamp with a specific text in a cell???

[@argenisaguilar9045]

Great..Thanks a lot...

[@cheewurz]

I like your Videos.

[@panorayasportsurabaya9964]

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

[@GBpetkov]

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

[@DanEMO592]

Amazing!!

[@mainulhasan2392]

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?

[@ExcelGoogleSheets]

Here you go kzbin.info/www/bejne/hJmoonanqZKhopY

[@mainulhasan2392]

@@ExcelGoogleSheets aye thanks man~! have a good day!

[@recoverycoordinator2651]

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.

[@ZILSANGHVI]

Can we lock cells based on color selected ? @Learn Google Spreadsheets

[@OctalCargo9584]

Is it possible to do this with multiples of certain numbers? ex. finding and formatting all multiples of two and changing their color.

[@ExcelGoogleSheets]

Yes, use formula to do conditional formatting. Watch the advanced video.

[@OctalCargo9584]

@@ExcelGoogleSheets Thank you

[@cheewurz]

I have a Particular Project I have a Question on if I may.

[@MrBirjujani]

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

[@ExcelGoogleSheets]

Example here kzbin.info/www/bejne/hJmoonanqZKhopY

[@jaieshkumar7768]

It only highlights the particular cell, what if I wanted to highlight the entire row

[@TReaL007]

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

[@karencepe5365]

hi need help, how can i use arrow instead of the color scale? in excel we have the choices.

[@mrcostco411]

Lets say I want a1 to turn black if b1 goes to 0 or below 0

[@cuneiformscript2665]

🙏🏻