•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
#row zero
#financial modeling with spreadsheets
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#Excel
#automatic highlighting
#rules
#color
#the grey cells
#highlighting tool
#fill
#=and()
#=or()
#cell value
#=1
#blue color
#green fill
#row