Hi, I have some tabular data on one spreadsheet in Excel 2016. One of the fields (columns, G in that case) is labeled "Active?", and the possible values are "Yes" and "No". I've created some conditional formatting rules to highlight a particular cell (A2, which is in the same row as G2) using a formula: =G2="No" (If G2 has a value of a literal "No"), then apply some formatting to A2. The idea is to turn the font color to grey on every cell in that row if the value in G2 is "No". However, I'd have to perform the same tedious job for cells B2, C2, D2...H2. This is not only tedious, it's also inflexible.
Is there a smarter way?
Thanks!
p.s. Sorry but I tried searching prior to posting, but the results page was taking abnormally long to load.
Bookmarks