Although I use advanced sheets for years, the way you explained Cond. Form. makes possible to understand the concept behind the logical thinking, like a programmer. After that I made some tests on a huge sheet and I could notice a new level of control of the conditional formatting. You made simple something no one could explain so clearly before. Congratulations!
Agree, I don't know anything about Excel other than We can can fill tables after watching this explanation I learnt lots of things the concept of conditional reasoning, How excel logically calculates this reasoning values, The syntax to do that, The ability to doing same conditional logic for other things than formatting when he used it in a separate cell. this video is more than informative.
why in my excel after selection of "Use a formula to determine which cells to format" what to do to have "Format values where this formula is true:" like aT 1:40mn of your video?? Thanks
I want data depending on cell status i have Active and Closed. So i have data in A,B and in C i have Active or Closed, So If i select Closed then data in A,B should add up and be displayed in column D, how can we do it?
Staffs name are in column A, Name starts from row 7. Visa status in column B, starts from row 7 as well, Hours status in Column C, starts from row 7 as well, etc.
Staff Visa Hours Can still work for Leave Name Status Status Hours Start End ABC PR 68:3015:30 DEF Citizen 75:308:30 GHI Student 77:007:00 JKL Citizen 57:3026:30
I am trying to calculate working hours in different color when condition change. PR and citizen can work upto 84 hours but students can only work 48 hours.
How to change a cell color in different condition.
I want to change C7 to green when Cell C7 is less than 84:00 but Cell B7 is PR or Citizen. And if Cell B7 is Student, cell C7 can only be green when C7 is less than 48:00
this only works when the cell contents are a value. if the cell that sets the condition contains a formula that returns a value, then you must use the Excel function VALUE so that conditional formatting will evaluate what the formula returns, rather than the formula itself. For example if cells in column E starting at row 7 contain formulas like =SUM(A7:D7) and you would like to format this group of cells based on the sum being more than 100, then your conditional formatting rule must be =VALUE(E7)>100. Otherwise conditional formatting is testing whether the text of the formula exceeds a number.
struggling to get this to work with cells already containing data validation. I want to create a drop down list wherein Column A (with validation) will format to maintain the same colour of Column B (data validation). Column b13 takes validation from a list in column X, and conditional colours of its own for text containing specific phrases "Phrase A" "Phrase B" etc when I use the formula: =$b13="Text Phrase" I'm getting no results in A13. verified that "apply selection to" says A13. feeling lost, please help if possible.
Thanks for sharing your video. Now there is something I'm itching to know. Question: Now how do you lock the formatting of the cells you entered the formula in so you can only input values? I want to still be able to copy paste but disable ( paste format / paste formula ) and only paste values. My form has different conditional formatting formula in different cells. So once I have my form set up I don't need to change the formatting / formula and in fact I don't want to change this. So how can I protect the sheet to assure I don't accidently change or add different "conditional formatting" to the cells?
Thank you very much for this video and information! Exactly what I was looking for in working on my own projects. Well put together video and very informative.
Hi just checking if i wanna format the cells in the below example how should the formula be? - if Cell B1 first value = 4 Cell d1 input = yes if Cell B1 first value = 5 Cell d1 input = no
imagine i have a range A1:A10 with specific numbers . and i have B1:D10 with numbers i want to compare with the numbers in A column. The point is that if number in row (example) 1 cell A1 = 40 . And B1 = 30 . C1 = 47 . D1 = 40. that the B1 changes font to Red . C1 changes to Orange . D1 changes color to Green. if i use your formula. Then even if B1 = 40 and C1:D1 = something else. The whole row 1 wil be lighted up green . how to fix it?
Hi, I am struggling to apply the conditional formatting based on other cell values. Kindly help. The case is, in one column I have qtrs. like Q-1, Q-2, Q-3 Q-4 and in other column there are branch codes and these branch codes are repetitive based on some activities. I want to highlight only those cells of branch codes column which are repetitive in that qtr. only. Suppose if I filter out Q-1, it will show only those cells which appear more than once in Q-1 only and likewise in other qtrs.
I don't know if this channel is still active. I hope so, because this video was informative, though it does not quite match what I'm trying to do. I am trying to auto-populate a price in one cell, based on a word in a different cell. As an example, in C2, the word would be "new" and in C3, I would like the price to be one amount, but if the word in C2 would be "senior", then I would like the price to be a different amount. Any help is appreciated.
Table looks like this in excel. A B C D E F 5 Staff Visa Hours Can still work for Leave 6 Name Status Status Hours Start End 7 ABC PR 68:3015:30 8 DEF Citizen 75:308:30 9 GHI Student 77:007:00 10 JKL Citizen 57:3026:30
I am trying to calculate working hours. PR and citizen can work upto 84 hours but students can only work 48 hours.
How to change a cell color in different condition.
I want to change C7 to green when Cell C7 is less than 84:00 but Cell B7 is PR or Citizen. If Cell B7 is Student, cell C7 can only be green when C7 is less than 48:00
If(B7=PR or Citizen and C7>84) C7 to turn red and if (B7=Student and C7>48) C7 to turn red Can some one help me please to solve this? Thank you
What if you want multiple options… not true and false. So I have a list of grades, A+ through F and I want certain columns to highlight certain colours based on the grade. How do I write that formula?
Hello After summation of a selected range in a row I need to subtract all the red font cells from the sum.PLEASE HELP ME OUT, as it takes lots of time to select manually……..
I want to do same thing but using Icon set, I get this error: "You cannot use relative references in Conditional Formatting criteria for color scales, data bars, and icon sets." What should I do? :(
Great explanation. It is possible to create a Formula to make a cell automatically fills-up with a specific number or text depending on the Color or Value, or Text from another cell in the same row ?
Very useful and easy to follow. I have a question: what if instead of “open” in that cell I have a date? How do I tell the conditional formatting that the row needs to be highlighted as long as in the C7 column there is date? I need this as I share a doc and colleagues will go in and complete tasks, once they complete the task they enter the date in which they completed and I want to see immediately when this happens by having the rows filled in. Thanks
I appreciate the way you explain this and I'm hoping you can help me. Your formula for 'open' works with data validation as well. I'm trying to lock an entire row and I have a cell with a data validation drop down with 'open' or 'closed' as its options. If I use your same formula with data validation I will not be able to type something new in that row if the cell is 'closed' but i can still hit delete or backspace to erase the data in that row. I also can't apply the formula to cells in that row that have a different data validation drop down menu. Do you know of a way to lock an entire low based on the contents of one cell in that row, regardless of the other formatting and data validation in the other cells?
Thank you for doing this! I wonder if there is a way or if you have a video that shows overflow or surplus of items. for example I enroll students into a school I need to know how many students are in a class in the school because as they progress through our program they will end up in class c with other students. how do I show that if i can only hold 100 students in class c that there will be an oveverflow of students and how much overflow there will be without counting by hand. im enrolling 15 students in class A based off where students are I can only have 10 more students in the overflow. I know I can count that but for enrollment of the whole year when students graduate or drop I have to plan out a few months ahead. so how can I say if greater than 100 than in another cell show the overflow of 5 or whatever the value is. is this possible? thank you if you can help!
Hi, how about if I want to clear values on colored cells? Not the whole row or column but just the highlighted ones. Or if I want to clear the cells based on the words on another cell? Thank you!
Can you create a formula that takes into account only columns that contain a certain word? For example, is it possible to create a sum of the “amounts” marked as open?
I want to be able to highlight a blank cell that has a formula. So my simpler second sheet is fed from the first by having a formula (eg =Sheet1!A1), but because there is a formula this does not work even though sheet1 cell A1 has no data. Help please?
Awesome thank you so much! I had not realised I could use a relative row reference in that formula. I was trying to reference the whole column C:C within my formula which uhhhh doesn't work...
I`m trying to do something with Excel that I can`t seem to explain properly. I have a formulated cell that will highlight my best price, out of 3 different other cells, but I want the cell chosen to be highlighted each time. Hard to explain. I wish I could show you. There must be a way.
Hi, what you share is great - Do you have an approach for a more complicated version of this? Specifically if I use conditional formatting to create a 3 point color graded format based on values - is there a way I can extend this formatting across a row?
Very nice video, may I ask one question? How can we protect columns dynamically while using conditional format OR Can we lock cells with conditional format dynamically with out VBA?
I’m putting this in here for others as I fought with my formula not working for about an hour. If you’re using true/false for highlighting it won’t work with quotes as the Boolean terms of true/false don’t need quotation marks.
The example formula used for 2 conditions was helpful for me. I had no idea what was wrong but the required formula was simple and didn't need IF or true/false components.
Thankyou so Much for this! Broken down perfectly! I love to know the reasons why I'm doing something not just being told what to do! I need the reason so this is perfect Thankyou!
thank you for your explanation, i’m currently taking a college excel class. and the book just gives us formulas with out truly explaining how to do it. this helped immensely in my application of this
Is it possible to add data to an existing Table(Calender)? I have a calender but would like to have data from a different workbook(s) automatically enter into dated cells.
Jeff thank you very much for all the time you put on this to help us understand how to use this very useful rpogram, I have a construction schedule, on the left side tasks, start date, end date and work datsy columns and on the right side weeks wolumns, cells on weeks are filled in reference to the dates on the left, can I use conditional formating for the cell results from the dates on the left columns but based on the specifc text I have on the task column, I want to use different colors for each task so people can see better in this eigth months schedule, I wish I can insert a screenshot for you to see, thank you
I had been struggling to understand this topic. I looked everywhere for a solution that told me what I needed to know and didn't confuse me more than I was at the start: Your video ticked both boxes, so Thank you... Your explanation was simple and to the point, and the fact that you emphasized the importance of the active cell made everything even clearer.
Thanks! I couldn't figure out how to do this myself. The confusing part was which cell I need to reference for relative references. You explained it perfectly!
Amazing m!! Looking to format a large amount of data but am struggling to figure out the best formula suitable for formatting a time scale set of data. Needs to read value of each set of data on each row by itself if this makes sense.. so Tiring 😢
This is a great video. I'm using a Data Validation drop down list (Sheet 1) where I select a customer name from my database (Sheet 2). I'd like to apply this video's conditional formatting but rather than highlight the row(s) on Sheet 1 - where my data validation and vlookup formulas are located, I'd like it to back to my database (Sheet 2) and highlight the rows of the customer names, that I've selected on Sheet 1. What do I need to change/add to Excel Universities formula to accomplish this? Thank you!
Thanks sir, but i have a challenging question, if you want a cell to be conditionally formatted based on the value in another cell but where the criteria is that, for example if cell c7 is up to 10% less than d7 then have a yellow colour and if its more than 10% less, then gives red colour, how is such a formula written in the conditional formatting tab?
Great video. Can you use wildcards in your formula? I am trying to conditionally format certain cells based on one cell having data in it, but that data changes every row that I want to format and cells in between don't have data in that cell.
Although I use advanced sheets for years, the way you explained Cond. Form. makes possible to understand the concept behind the logical thinking, like a programmer. After that I made some tests on a huge sheet and I could notice a new level of control of the conditional formatting. You made simple something no one could explain so clearly before. Congratulations!
Thank you so much for your kind note, I sincerely appreciate it ... and glad the video was helpful :)
Agree, I don't know anything about Excel other than We can can fill tables after watching this explanation I learnt lots of things the concept of conditional reasoning, How excel logically calculates this reasoning values, The syntax to do that, The ability to doing same conditional logic for other things than formatting when he used it in a separate cell. this video is more than informative.
I tried this referencing another cell OUTSIDE the selected range and it did not work for me. Is there a way to do that?
You explained this so well, thank you for taking time to explain vs. simply sharing the formula.
why in my excel after selection of "Use a formula to determine which cells to format" what to do to have "Format values where this formula is true:" like aT 1:40mn of your video?? Thanks
Thanks for explaining this so thoroughly, yet slow enough to make sense. I can see myself watching a LOT of your videos in the near future!
Glad to help … and thanks for your kind note!
conditional format based on a row? or a column?
I want data depending on cell status i have Active and Closed. So i have data in A,B and in C i have Active or Closed, So If i select Closed then data in A,B should add up and be displayed in column D, how can we do it?
hi, can we do format cells based on different sheet ?
Staffs name are in column A, Name starts from row 7. Visa status in column B, starts from row 7 as well, Hours status in Column C, starts from row 7 as well, etc.
Staff Visa Hours Can still work for Leave
Name Status Status Hours Start End
ABC PR 68:30 15:30
DEF Citizen 75:30 8:30
GHI Student 77:00 7:00
JKL Citizen 57:30 26:30
I am trying to calculate working hours in different color when condition change. PR and citizen can work upto 84 hours but students can only work 48 hours.
How to change a cell color in different condition.
I want to change C7 to green when Cell C7 is less than 84:00 but Cell B7 is PR or Citizen.
And if Cell B7 is Student, cell C7 can only be green when C7 is less than 48:00
Can someone help me, please.
Thank you
this only works when the cell contents are a value. if the cell that sets the condition contains a formula that returns a value, then you must use the Excel function VALUE so that conditional formatting will evaluate what the formula returns, rather than the formula itself. For example if cells in column E starting at row 7 contain formulas like =SUM(A7:D7) and you would like to format this group of cells based on the sum being more than 100, then your conditional formatting rule must be =VALUE(E7)>100. Otherwise conditional formatting is testing whether the text of the formula exceeds a number.
struggling to get this to work with cells already containing data validation.
I want to create a drop down list wherein Column A (with validation) will format to maintain the same colour of Column B (data validation). Column b13 takes validation from a list in column X, and conditional colours of its own for text containing specific phrases "Phrase A" "Phrase B" etc
when I use the formula: =$b13="Text Phrase"
I'm getting no results in A13. verified that "apply selection to" says A13.
feeling lost, please help if possible.
Same Question...
@@chrismay2707 wish we could find out im still sitting on this project
Thanks for sharing your video. Now there is something I'm itching to know.
Question: Now how do you lock the formatting of the cells you entered the formula in so you can only input values?
I want to still be able to copy paste but disable ( paste format / paste formula ) and only paste values. My form has different conditional formatting formula in different cells. So once I have my form set up I don't need to change the formatting / formula and in fact I don't want to change this. So how can I protect the sheet to assure I don't accidently change or add different "conditional formatting" to the cells?
Thank you very much for this video and information! Exactly what I was looking for in working on my own projects. Well put together video and very informative.
Thank you for your kind note, and I'm glad it helped!!
Hi just checking if i wanna format the cells in the below example how should the formula be? -
if Cell B1 first value = 4 Cell d1 input = yes
if Cell B1 first value = 5 Cell d1 input = no
imagine i have a range A1:A10 with specific numbers . and i have B1:D10 with numbers i want to compare with the numbers in A column.
The point is that if number in row (example) 1 cell A1 = 40 . And B1 = 30 . C1 = 47 . D1 = 40. that the B1 changes font to Red . C1 changes to Orange . D1 changes color to Green.
if i use your formula. Then even if B1 = 40 and C1:D1 = something else. The whole row 1 wil be lighted up green .
how to fix it?
Hi, I am struggling to apply the conditional formatting based on other cell values. Kindly help.
The case is, in one column I have qtrs. like Q-1, Q-2, Q-3 Q-4 and in other column there are branch codes and these branch codes are repetitive based on some activities. I want to highlight only those cells of branch codes column which are repetitive in that qtr. only.
Suppose if I filter out Q-1, it will show only those cells which appear more than once in Q-1 only and likewise in other qtrs.
I don't know if this channel is still active. I hope so, because this video was informative, though it does not quite match what I'm trying to do.
I am trying to auto-populate a price in one cell, based on a word in a different cell.
As an example, in C2, the word would be "new" and in C3, I would like the price to be one amount, but if the word in C2 would be "senior", then I would like the price to be a different amount.
Any help is appreciated.
Table looks like this in excel.
A B C D E F
5 Staff Visa Hours Can still work for Leave
6 Name Status Status Hours Start End
7 ABC PR 68:30 15:30
8 DEF Citizen 75:30 8:30
9 GHI Student 77:00 7:00
10 JKL Citizen 57:30 26:30
I am trying to calculate working hours. PR and citizen can work upto 84 hours but students can only work 48 hours.
How to change a cell color in different condition.
I want to change C7 to green when Cell C7 is less than 84:00 but Cell B7 is PR or Citizen.
If Cell B7 is Student, cell C7 can only be green when C7 is less than 48:00
If(B7=PR or Citizen and C7>84) C7 to turn red and if (B7=Student and C7>48) C7 to turn red
Can some one help me please to solve this?
Thank you
What if you want multiple options… not true and false. So I have a list of grades, A+ through F and I want certain columns to highlight certain colours based on the grade. How do I write that formula?
Hello
After summation of a selected range in a row I need to subtract all the red font cells from the sum.PLEASE HELP ME OUT, as it takes lots of time to select manually……..
Nice, thanks! Why isn't conditional formatting retained if you Refresh or make any changes? Thanks
Wonderful, you helped me do something I have been trying for ages how to get a line formated when the date (in column A) is today - =$A2=TODAY()
Excellent!
I want to do same thing but using Icon set, I get this error:
"You cannot use relative references in Conditional Formatting criteria for color scales, data bars, and icon sets."
What should I do? :(
obsessed with soft design now and more obsessed with cool scales Nd stuff.
Great explanation. It is possible to create a Formula to make a cell automatically fills-up with a specific number or text depending on the Color or Value, or Text from another cell in the same row ?
Very useful and easy to follow.
I have a question: what if instead of “open” in that cell I have a date?
How do I tell the conditional formatting that the row needs to be highlighted as long as in the C7 column there is date?
I need this as I share a doc and colleagues will go in and complete tasks, once they complete the task they enter the date in which they completed and I want to see immediately when this happens by having the rows filled in.
Thanks
I appreciate the way you explain this and I'm hoping you can help me. Your formula for 'open' works with data validation as well. I'm trying to lock an entire row and I have a cell with a data validation drop down with 'open' or 'closed' as its options. If I use your same formula with data validation I will not be able to type something new in that row if the cell is 'closed' but i can still hit delete or backspace to erase the data in that row. I also can't apply the formula to cells in that row that have a different data validation drop down menu.
Do you know of a way to lock an entire low based on the contents of one cell in that row, regardless of the other formatting and data validation in the other cells?
Thank you for doing this! I wonder if there is a way or if you have a video that shows overflow or surplus of items. for example I enroll students into a school I need to know how many students are in a class in the school because as they progress through our program they will end up in class c with other students. how do I show that if i can only hold 100 students in class c that there will be an oveverflow of students and how much overflow there will be without counting by hand. im enrolling 15 students in class A based off where students are I can only have 10 more students in the overflow. I know I can count that but for enrollment of the whole year when students graduate or drop I have to plan out a few months ahead. so how can I say if greater than 100 than in another cell show the overflow of 5 or whatever the value is. is this possible? thank you if you can help!
That explanation technique was just WOW!
Thank you so much, I really appreciate your kind note!!!
Hi, how about if I want to clear values on colored cells? Not the whole row or column but just the highlighted ones. Or if I want to clear the cells based on the words on another cell? Thank you!
Can you create a formula that takes into account only columns that contain a certain word? For example, is it possible to create a sum of the “amounts” marked as open?
Hi! I answered your question by creating a new video: ua-cam.com/video/6_dUUR4NT04/v-deo.html
I hope it helps!
Thanks
Jeff
What about if the status of cell A checked, then stop conditional formatting in cell B? How can I do that?
Thank you very much for this video and information! Nice Explanation!!👌👌👌
Thanks!
when I click on "new rule" under conditional formatting, I dont see any of the options you select
But what if your good numbers are the lowest, I seem to only get opptions for greater values?
I have seen many excel teaching videos.. I can honestly say, you know how to teach. Awsome channel.
Thank you so much, I sincerely appreciate your kind note :)
The best video on UA-cam explaining the syntax behind appropriate conditional formatting, thanks for making this!
Thank you for your kind note :)
Thank you so much! It solved the problem I was having at work. I used to spend lots of time highlighting rows. All of your videos are super helpful.
Glad it was helpful ... and thank you so much for your kind note :)
Explained everything really well, easy to follow, great teaching technique.
Glad you enjoyed it!
Excellently explained and has really helped me with a work project. Thanks!
Thank you :)
You are a good teacher. Thank you.
Thank you :)
Can I format a cell based on another cell and when it changes it changes
i have a column of yes and no and i wnat to highlight all the Yes values when there is a no value after it in the column
I want to be able to highlight a blank cell that has a formula. So my simpler second sheet is fed from the first by having a formula (eg =Sheet1!A1), but because there is a formula this does not work even though sheet1 cell A1 has no data. Help please?
Super helpful and explained well!
Awesome thank you so much! I had not realised I could use a relative row reference in that formula. I was trying to reference the whole column C:C within my formula which uhhhh doesn't work...
Nice tutorial Michael,
Thanks!!
I`m trying to do something with Excel that I can`t seem to explain properly. I have a formulated cell that will highlight my best price, out of 3 different other cells, but I want the cell chosen to be highlighted each time. Hard to explain. I wish I could show you. There must be a way.
My formula doesnt work.. did it the same as you. =$C15="Text" doesnt work.
Hi, what you share is great - Do you have an approach for a more complicated version of this?
Specifically if I use conditional formatting to create a 3 point color graded format based on values - is there a way I can extend this formatting across a row?
Very nice video, may I ask one question?
How can we protect columns dynamically while using conditional format OR Can we lock cells with conditional format dynamically with out VBA?
How do I apply conditional formating to a check box where the box being checked applies the formula?
This was a great help, thank you. But four of my rows didn't format while the rest did. I can't figure out why.
Superb Explanation. Also I like the key explanation about locking the cells when we need to highlight complete row. Thank you So Much 💖
I’m putting this in here for others as I fought with my formula not working for about an hour.
If you’re using true/false for highlighting it won’t work with quotes as the Boolean terms of true/false don’t need quotation marks.
Spot on - Very good explanation of conditional formatting I have ever seen. Most of the problems solved
The example formula used for 2 conditions was helpful for me. I had no idea what was wrong but the required formula was simple and didn't need IF or true/false components.
Thankyou so Much for this! Broken down perfectly! I love to know the reasons why I'm doing something not just being told what to do! I need the reason so this is perfect Thankyou!
thank you for your explanation, i’m currently taking a college excel class. and the book just gives us formulas with out truly explaining how to do it. this helped immensely in my application of this
This is extremely helpful, thank you so much!
Glad it was helpful :)
That was Amazing! Thank you for perfectly clear explanation!
Can this be used for cells that are not connected to each other?
Excellent! I have forgotten so much. Thank you for bailing out an old man...
Is it possible to add data to an existing Table(Calender)? I have a calender but would like to have data from a different workbook(s) automatically enter into dated cells.
Dope explanation. Please make more content, I just subscribed.
Thanks Paul
Jeff thank you very much for all the time you put on this to help us understand how to use this very useful rpogram, I have a construction schedule, on the left side tasks, start date, end date and work datsy columns and on the right side weeks wolumns, cells on weeks are filled in reference to the dates on the left, can I use conditional formating for the cell results from the dates on the left columns but based on the specifc text I have on the task column, I want to use different colors for each task so people can see better in this eigth months schedule, I wish I can insert a screenshot for you to see, thank you
I had been struggling to understand this topic. I looked everywhere for a solution that told me what I needed to know and didn't confuse me more than I was at the start: Your video ticked both boxes, so Thank you... Your explanation was simple and to the point, and the fact that you emphasized the importance of the active cell made everything even clearer.
Thanks! I couldn't figure out how to do this myself. The confusing part was which cell I need to reference for relative references. You explained it perfectly!
Great video! I am trying to get it to recognize if a specific letter, like x is in a column at least 3 times. What could that formula look like?
THANK YOU!! Excellent explanation and pace of video
Great explanation. What if I want to format based on values in a list regardless of which one matches?
What if condition is a calculated value?
Excellent!! I just try to find answer for this for hours!!! Greetings from Finland.
Amazing m!! Looking to format a large amount of data but am struggling to figure out the best formula suitable for formatting a time scale set of data. Needs to read value of each set of data on each row by itself if this makes sense.. so Tiring 😢
How can I do it so that it is still a 3 point colour scale?
Can you please do a video on how to highlight the whole row is only some cells are highlighted (N.B : but the cells are not common)
This was excellent. Very easy to adjust for using Google Sheets for my home use as well!
Thank you - Very well explained - I sure learned something and I am going to use it.
This helped for what I was looking for. Gracias! :)
Thank you for this video! I've been struggling with conditional formatting and now I know what I was doing wrong!
Is there a way to do this but in a Pivot Table and using the source data for the conditional formatting?
perfect explanation
Thank you so much! New fan and subscriber!
Well presented Sir !!!! Nice video
Thank you!
excellent explain and new information. Thanks bro
Muchísimas gracias por compartir este conocimiento
Thanks for the wonderful tutorial sir
thorough! helpful!
Solved my problem. Thanks!
i want to use conditional formatting if any value changes in that cell not relative to another cell
Good explanation!
Thanks!
this really helped me a lot. thank you for this wisdom.
This is a great video. I'm using a Data Validation drop down list (Sheet 1) where I select a customer name from my database (Sheet 2). I'd like to apply this video's conditional formatting but rather than highlight the row(s) on Sheet 1 - where my data validation and vlookup formulas are located, I'd like it to back to my database (Sheet 2) and highlight the rows of the customer names, that I've selected on Sheet 1. What do I need to change/add to Excel Universities formula to accomplish this? Thank you!
Hi @davemotz1139
I've answered your question in a new video: ua-cam.com/video/SPF6r7M9BLQ/v-deo.html
Hope it helps :)
Thanks
Jeff
Thanks sir, but i have a challenging question, if you want a cell to be conditionally formatted based on the value in another cell but where the criteria is that, for example if cell c7 is up to 10% less than d7 then have a yellow colour and if its more than 10% less, then gives red colour, how is such a formula written in the conditional formatting tab?
Hi @mm22sapphire50
I have created a new video to help with your question: ua-cam.com/video/j11JEElc9O8/v-deo.html
I hope it helps :)
Thanks
Jeff
Great video. Can you use wildcards in your formula? I am trying to conditionally format certain cells based on one cell having data in it, but that data changes every row that I want to format and cells in between don't have data in that cell.
Unvaluable explanation, thank you.
Your explanation was very well done.
Thanks!!
thanks