SOLVED

Conditional Formatting

Copper Contributor

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.

Capture.JPG

 

2 Replies
best response confirmed by emilyfay (Copper Contributor)
Solution

@emilyfay 

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.
1 best response

Accepted Solutions
best response confirmed by emilyfay (Copper Contributor)
Solution

@emilyfay 

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.

 

View solution in original post