DocHub makes it quick and simple to strike out light in xls. No need to instal any software – simply add your xls to your profile, use the easy drag-and-drop user interface, and quickly make edits. You can even use your PC or mobile device to adjust your document online from anywhere. That's not all; DocHub is more than just an editor. It's an all-in-one document management solution with form constructing, eSignature capabilities, and the option to let others complete and sign documents.
Every file you edit you can find in your Documents folder. Create folders and organize records for easier search and retrieval. Furthermore, DocHub guarantees the security of all its users' data by complying with strict protection protocols.
hi welcome now i am going to show you how to create or show traffic lights for a set of values depending on the uh the range of the values okay so what i have here is for the months from january to december and the sales in thousands okay so what iamp;#39;m going to do is for a green iamp;#39;m going to introduce traffic lights for these values okay these values if it is uh greater than or 700 then i want to show it in green okay this one okay and this one and so on okay if it is the greater than or equal to 200 to 700 i want to show it in yellow okay so it is in the medium range green is the higher range and if it is less than 200 i want to show it in red okay just on my traffic lights criteria okay using this criteria iamp;#39;m going to show the traffic value lights for these values okay how can i do that first i need to select the data values then iamp;#39;ll go to home then conditional formatting in the conditional formatting there is something called icon set okay in the conc