Hi friends recently while working with excel I just try this thing that, I just want to check a column (lets say H) if there is a 1 value i want excel to color the row. Let’s say there is a 1 on H6, I want to fill a color to row 6. It can be full coloring or if i can i might like to range it to A6:J6. So I just want to know how can it be possible in Excel and what I have to do to make this thing happens in Excel, so if you guys have any of the information then please let me know.
Bookmarks