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!
Thank you so much sir ....
Thx. It was easy bcoz you explained it in simple words
Thank you, Richard Hammond!
Awesome thank you
Thank you!
Thank you for your lesson
Thank You
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!
Thank u very much
Thanks, sir, very informative video.
Thank you soo much for this 🤗
Thanks very clear
Good Morning Sir
Very good, thank u
Sir u r great it helps me a lot
Very nice
Jatinder, thank you very much ❤❤❤
Gooday what if you habe five coulours in a scale for performznce review
Can we highlight month field also using color scale?
Awesome
Sir I have questions how I can colour from sheet 2 into sheet 1 as per selected data in sheet 2
Good
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...
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
Hey... I have a question... Pls tell your not reply my comments and dought questions? Why??
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!
Thank you
Thank you so much sir ....
Glad it was helpful! :)
Thank you