Have you ever struggled with modifying your Spreadsheet document while on the go? Well, DocHub has a great solution for that! Access this online editor from any internet-connected device. It allows users to Replace highlight in Spreadsheet files quickly and whenever needed.
DocHub will surprise you with what it provides you with. It has robust functionality to make whatever changes you want to your forms. And its interface is so intuitive that the whole process from beginning to end will take you only a few clicks.
When you complete editing and sharing, you can save your updated Spreadsheet document on your device or to the cloud as it is or with an Audit Trail that contains all modifications applied. Also, you can save your paperwork in its original version or convert it into a multi-use template - complete any document management task from anywhere with DocHub. Subscribe today!
hey guys I want to show you how to highlight an entire row a certain color based on a cell value so in this case if I select active from this drop-down menu I would want this to automatically turn green and if I select injured I want this to automatically turn red so the way that you do that is that you click on format and conditional formatting and then its going to ask you which range you want to apply it to you so you want to highlight wherever you want the color to show so I wanted to show from I wanted it to effect all cells from a2 to all of D right so Im gonna go from 82 to all of D and then you want to change this to custom formula and then this is where you type in your if statement so you type in so Im saying equals D to 2d because this is where the cell value is gonna be D 2 to D equals in quotes active you could type it exactly like how you have it on here okay and end quotes and then when you do that its going to highlight just the first column green and the way that y