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

Conditional formatting of a row based on data in one column and a blank in another

Our take

Are you tired of manually identifying which rows in your spreadsheet need attention? Conditional formatting can streamline this process, allowing you to visually highlight important data points effortlessly. By setting up a rule that highlights cells in column C yellow when there’s data in column B but a blank in column C, you can enhance your data’s clarity at a glance. In this guide, we'll provide the precise formula you need to implement this conditional formatting across all rows, transforming your workflow for the better.

I want to set conditional formatting for rows so when there is data in column B but a blank in column C, the cell in column C is highlighted yellow. I want this to apply to all rows.

What formula do I need?

Thanks in advance.

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

Read on the original site

Open the publisher's page for the full experience

View original article

Related Articles

Tagged with

#rows.com#Excel alternatives for data analysis#generative AI for data analysis#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#natural language processing for spreadsheets#AI formula generation techniques#Excel compatibility#row zero#cloud-based spreadsheet applications#conditional formatting#data#formula#column B#column C#blank#rows#highlighted