1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to apply conditional formatting to multiple columns based off of data in one column

Hello, I am working on a spreadsheet where I would like both columns B and C to change to the same color based on the information in column B, regarless of what it says in column C. For example, column B might read "Tan" and column C reads "Brick Yellow", but I want both cells to change to the formatting that I select for the word "Tan". Any help is appreciated! Thanks

submitted by /u/Academic_Angle_6333
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#cloud-based spreadsheet applications
#natural language processing for spreadsheets
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#Excel alternatives
#spreadsheet API integration
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration