Thanks for your help but kindly let me know, if there is a way to apply these conditional formatting to any single/particular cell (in vertical) just to.. kind of giving a shade please.. ? Thank you!
Is there a way to create a horizontal colored scale, with only the low and high numbers listed, plus a single number between them identified via a symbol? For example, let's say I want to show on a colored scale that I got 250 points out of 300, how could i create that using a colored scale?
I imagine I could just number cells horizontally (instead of vertically) to achieve the horizontal colored scale. But i dont know how i could hide the values while keeping the colors, plus pinpointing/identifying a specific number within the range that may not be in the exact numerical increments as the values
is there a way to make the colour of a cell similar colour but lighter shade to one next to it? - eg for budgetting i set colours based on "type" eg bills is Peach, using my bank card is Purple, direct debits are red/pink, income is green.. but i set the cell with the "Home/fill Green Accent 60%" via theribbon and the "info" cell is the same but "accent 40%" -- im prob not explaining it well as its hard to discribe.. but is there a way to automate this so im not changing the colours several times when i update my budget? - eg if i set cell D5 to purple accent 60% i want E5 to be Purple accent 40% or something automatically. as colour scales dont seem to work with text as far as i can try
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
I have yet to find a tutorial on how to use the formula type on a 3-colour scale. This tutorial even says it will just explain the simple ones... grrr!
![[#2024MAMA] BIGBANG (빅뱅) - 뱅뱅뱅 (BANG BANG BANG) + FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/EQsYfiPR9uM/mqdefault.jpg)
Awesome thank you
Thx. It was easy bcoz you explained it in simple words
Thank you, Richard Hammond!
Thank you for your lesson
Thank you!!
Thank you!
you are the best thanks
Thanks for your help but kindly let me know, if there is a way to apply these conditional formatting to any single/particular cell (in vertical) just to.. kind of giving a shade please.. ?
Thank you!
Gooday what if you habe five coulours in a scale for performznce review
Thank u very much
Thank you soo much for this 🤗
Thanks, sir, very informative video.
Very good, thank u
Sir u r great it helps me a lot
Thanks very clear
Very nice
Jatinder, thank you very much ❤❤❤
Good Morning Sir
Can we highlight month field also using color scale?
Thank you so much sir ....
Glad it was helpful! :)
Sir I have questions how I can colour from sheet 2 into sheet 1 as per selected data in sheet 2
Is there a way to create a horizontal colored scale, with only the low and high numbers listed, plus a single number between them identified via a symbol? For example, let's say I want to show on a colored scale that I got 250 points out of 300, how could i create that using a colored scale?
I imagine I could just number cells horizontally (instead of vertically) to achieve the horizontal colored scale. But i dont know how i could hide the values while keeping the colors, plus pinpointing/identifying a specific number within the range that may not be in the exact numerical increments as the values
Easy to learn , Thanks
Subramani You’re Welcome :)
@@ExcelTutorialsEasyClickAcademy can you share me your mail id . I have doubt in excel
How to adjust negative value as dark red to light red and positive values as dark green to light green...
Awesome
is there a way to make the colour of a cell similar colour but lighter shade to one next to it? - eg for budgetting i set colours based on "type" eg bills is Peach, using my bank card is Purple, direct debits are red/pink, income is green.. but i set the cell with the "Home/fill Green Accent 60%" via theribbon and the "info" cell is the same but "accent 40%" -- im prob not explaining it well as its hard to discribe.. but is there a way to automate this so im not changing the colours several times when i update my budget? - eg if i set cell D5 to purple accent 60% i want E5 to be Purple accent 40% or something automatically. as colour scales dont seem to work with text as far as i can try
Good
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
Thank you
I have yet to find a tutorial on how to use the formula type on a 3-colour scale. This tutorial even says it will just explain the simple ones... grrr!
Hey... I have a question... Pls tell your not reply my comments and dought questions? Why??
Thank you so much sir ....
Thank you
Thank You