•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
What will make the grey cells in the automatic Excel highlight rule turn into the correct highlighting color (blue color in this case)?
I am using the Excel automatic highlighting tool with these rule =and(row()=cell("row"), column()=cell("col")) -> red color as well as =or(row()=cell("row"), column()=cell("col")) -> blue color
Apart from that I also have the rule that it formats with a green fill if cell value equals to =1
The problem is that I have fields with a grey fill now whenever I click on a row where there is already a green field. How do I make these remaining grey fields blue as well as?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com