Forum Discussion
Conditional Formatting
Hello, I am trying to highlight cells based on what column B in my spreadsheet says, and also whether or not a cell is blank. So Column B has insurance types, and I need to highlight the smaller cells in those rows for "Med A", but stop highlighting them once a cell is filled. I don't have any formulas in the smaller cells to make them not empty, they are completley blank, so I am not sure how to go about adding the extra "cell is blank" parameter.
Let's say the data begin in row 2.
Select E2:E100 or however far down you want.
E2 should be the active cell in the selection.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND($B2="Med A",E2<>"")
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
You can now use the Format Painter to copy the formatting, including the conditional formatting rule, from E2:E100 to G2:G100, I2:I100 etc.
2 Replies
Let's say the data begin in row 2.
Select E2:E100 or however far down you want.
E2 should be the active cell in the selection.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND($B2="Med A",E2<>"")
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
You can now use the Format Painter to copy the formatting, including the conditional formatting rule, from E2:E100 to G2:G100, I2:I100 etc.
- Thank you! For some reason my brain didn't tell me to put the E2 in there, I was just putting the <>"" thinking it would pick up the cell on its own.
