Very amazing thank you :) Trying to make sense of spreadsheets when looking for your first apartment is a real pain but this helps a lot! Keep up the good work :)
Very helpful. Thank you! I'm wondering about more complex combinations of conditions, like if the value in B3 is true AND the the value in B2 is "PT" then color the row green.
Sure thing. To do this, use the following custom formula: =AND(B3=TRUE, B2="PT") Explanation: AND() checks if multiple conditions are true simultaneously. B3=TRUE checks if the value in cell B3 is the boolean value TRUE. B2="PT" checks if the value in cell B2 is the text "PT".
What if I want to have the entire row be colored, but only based on one columns Color Scale? Im looking to have a scale from 1-10 and the rows then also be highlighted according to that one column.
Hi. I wonder how you can have an open set of fields that you want to be flexible with, and change the individual cell's format, but a group of fields that will individually change to those formats when you put in just the word? To explain my self. I have a list that could say and formatted -- unassigned - white field, regular black text start - white field, bold black text in progress - blue field, bold yellow text 80% complete - green field, bold yellow text etc... and the list grid will have the single fields change to those when I just enter the word. but I also want to add a differenct word and format whenever I want, that will change in the grid's individual field too.
The same is happening to me and I found the solution. In the range, don't start in the 1 row but the 2. Don'ti use A1:x1000 and use A2:x1000 It worked for me ;-)
How can I have multiple conditiong formating based on values of another cells? let me explain by example I have few tables each with 3 headers with 3 drop down options: Empty, Control, Detail Now, I want the content of the table rows below remain blank as defoult. As soon as I start typying in ithat cells I want it to turn yellow. That part I can do by using siple conditioning formating on that cells. However I want to add one more extra factor - if the header is "Detail" (or any othe cell without drop down) I want cell colour change to green. So, in a nuthell want to be able to write custo conditioning formula which goes something like that C1=if empty = blank/white, if not empty = yellow, If not empty and B1="Detail" = green Anybody know how to tackle this?
10:12 This is exactly what ive been trying to do. The problem is, the cell that Im trying to base it on says "Sunday", but it's not actually a text that says "Sunday". It's a date that I format to display days. So I want every row that says Sunday to be red. I tried putting like =B2="Sunday", but it didn't work Can you help me out?
Would the following work? Select the range of cells you want to format based on the day. Go to the Home tab and click Conditional Formatting. Choose New Rule. Select Use a formula to determine which cells to format. In the formula box, enter: =WEEKDAY(B2)=1 (replace B2 with your actual cell reference). Click Format.... Choose the desired formatting (e.g., red fill). Click OK twice. This formula checks if the weekday number returned by WEEKDAY(B2) is 1, which corresponds to Sunday. If true, the formatting will be applied.
Good one Scott ... I use conditional formatting a lot but didn't know about the option to select the entire spreadsheet ... Nice ... Thanks again!
You're very welcome, Bill. Yes, I like having this option available depending on what I'm trying to zero in on.
Very amazing thank you :) Trying to make sense of spreadsheets when looking for your first apartment is a real pain but this helps a lot! Keep up the good work :)
You're so welcome! Wishing you all the best as you find that first apartment!
I like the way you explain with simplicity
I'm so glad that you found this helpful and enjoy my way of teaching. Thanks for sharing!
Very clear and simply explained, thanks
You are welcome!
Thank you! Helped a lot which a sheet I made tracking the progress of my studies!
You're very welcome!
Thank you! This was very helpful.
You're welcome!
Very helpful. Thank you! I'm wondering about more complex combinations of conditions, like if the value in B3 is true AND the the value in B2 is "PT" then color the row green.
Sure thing. To do this, use the following custom formula:
=AND(B3=TRUE, B2="PT")
Explanation:
AND() checks if multiple conditions are true simultaneously.
B3=TRUE checks if the value in cell B3 is the boolean value TRUE.
B2="PT" checks if the value in cell B2 is the text "PT".
Thank you so much!!!
really helpful. Simple to follow 🙏
So glad you enjoyed this one!
Thank you- easy to follow you. What formula can I use when I want only empty cells in a column of the whole sheet highlighted?
Very enlightening and informative.
Glad you found it helpful!
What if I want to have the entire row be colored, but only based on one columns Color Scale? Im looking to have a scale from 1-10 and the rows then also be highlighted according to that one column.
This is very cool, thank you so much.
You're very welcome!
great information. Well done
Hi. I wonder how you can have an open set of fields that you want to be flexible with, and change the individual cell's format, but a group of fields that will individually change to those formats when you put in just the word?
To explain my self. I have a list that could say and formatted --
unassigned - white field, regular black text
start - white field, bold black text
in progress - blue field, bold yellow text
80% complete - green field, bold yellow text
etc...
and the list grid will have the single fields change to those when I just enter the word.
but I also want to add a differenct word and format whenever I want, that will change in the grid's individual field too.
Tq for sharing this video
You're welcome!
Well done -- but -- it doesn't tell me how a condition in say column B can set its resulting color in the same Row, but one row up . . .
The same is happening to me and I found the solution. In the range, don't start in the 1 row but the 2. Don'ti use A1:x1000 and use A2:x1000 It worked for me ;-)
I want to use borders in conditional formatting. I know this can be done in excel. Is there a workaround for it in google sheets?
Sorry, but conditional formatting with borders is currently not available.
Thanks for How to product the same sheet but multiple user control in same sheet
exm, A column only edit Mr. A B column only edit Mr. B how to do this
How can I have multiple conditiong formating based on values of another cells? let me explain by example
I have few tables each with 3 headers with 3 drop down options: Empty, Control, Detail
Now, I want the content of the table rows below remain blank as defoult. As soon as I start typying in ithat cells I want it to turn yellow. That part I can do by using siple conditioning formating on that cells. However I want to add one more extra factor - if the header is "Detail" (or any othe cell without drop down) I want cell colour change to green.
So, in a nuthell want to be able to write custo conditioning formula which goes something like that
C1=if empty = blank/white, if not empty = yellow, If not empty and B1="Detail" = green
Anybody know how to tackle this?
10:12 This is exactly what ive been trying to do.
The problem is, the cell that Im trying to base it on says "Sunday", but it's not actually a text that says "Sunday". It's a date that I format to display days.
So I want every row that says Sunday to be red.
I tried putting like =B2="Sunday", but it didn't work
Can you help me out?
Would the following work?
Select the range of cells you want to format based on the day.
Go to the Home tab and click Conditional Formatting.
Choose New Rule.
Select Use a formula to determine which cells to format.
In the formula box, enter: =WEEKDAY(B2)=1 (replace B2 with your actual cell reference).
Click Format....
Choose the desired formatting (e.g., red fill).
Click OK twice.
This formula checks if the weekday number returned by WEEKDAY(B2) is 1, which corresponds to Sunday. If true, the formatting will be applied.
yooo that's smart. thank you my good sir. this actually works exatcly the way i want it to@@Simpletivity
I'm so glad to hear that. You're very welcome!
google sheet me ham kisi word ko colour den to automatically apne jese colour ke sath mil jae esa hoskta he