Conditional Formatting with Color Scale using Google Sheets

[@baden271]

What if I want the whole row to be affected base on the data from a specific column?

[@tysongoudie6158]

Thanks! Also your computer is about to launch off to the moon sounds like 😂

[@YashPatel-rg5uo]

Thanks a lot !! Tutorial is recorded inside a plane just before take off 🛫

[@jonrods3415]

Thanks for the video. Do you know how to do data bars inside the cells. thank you

[@TheWinghochui]

Thanks for your sharing!

[@bastiaanwilliams8398]

The problem with this is that it does not work when using filters. The color of a specific row will not change because the color scale is always for the whole value of the row, filtered out or not. A Google App Script would work much better when using filtered data.

[@steveworrell]

This is great. Thank you for making this video. However. What I need is not only the colour range like you have but also the colour hex code associated with each cell. Is this possible.

[@marksteel3289]

Hi, this is the closest thing I've found to what I need. I need to create a schedule for maintenance works. We service AC in hotels every 3 months so I'd like to have a tickbox but also register the date and colour the cell or tickbow green. then once 3 months has elapsed change the colour to yellow. After 4 months it would change to red to alert me we are overdue. Can you let meknow if this is possible and how to do this pleasse.

[@ashleycam3ron]

Hello! I'm planning to make a conditional formatting video soon, thanks to your comment! I use conditional formatting on my business records for dates & invoicing. It may be of use. I'll try to remember to comment back when I post the video.

[@jaandel1]

​@@ashleycam3ronhiw can you get color code using formatting conditional

[@ashleycam3ron]

Hello! Here's a new video I posted for tips on creating a maintenance schedule template: kzbin.info/www/bejne/jqvPc6yHe8eFsNk I hope it helps with the document type you are creating. My template is also available for download in my shop: tinyurl.com/gs-schedule-template Cheers, Ashley

[@marksteel3289]

This looks great Ashley, thanks for sharing! 😊 🙏🏼

[@NazranaStudioOnlySad]

How to blank column row without data entry colour grayscale after fild row data colour diffrent automatically

[@kennethbattaglia2994]

can you create multiple mid points?

[@supriyosenapati6115]

very nice madam. It helped me

[@FernandoCuesta-f4d]

Amazing, thanks. ❤❤

[@divyakalapala4164]

Tq❤

[@jameswkinsella]

Are you zooey deschanel?

[@ashleycam3ron]

😂 No, but I keep getting comments that I sound like her. Unsure if that's good or bad. 🤷‍♀️

[@ninnicouoh4790]

Thank you 🎉

[@destroyerag7800]

I did this but the coordinates are B2:B36 but the color scale ends at B4:B36 so its leaving 2 other numbers out

[@kacperborowy1400]

helped for homework thx

[@averypiper9833]

thank you!

[@dradelzakharydentalclinic]

you need to get that fan cleaned I can hear the fan

[@mahendraroliya8695]

thanks

[@isaacnoobysmolbrain]

Why is there just a jet engine slowly powering up in the background💀💀💀

[@poodawg]

Come to brazil

[@mahendraroliya8695]

thanks