May 17 2021 02:45 PM - edited May 17 2021 02:46 PM
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.
May 17 2021 02:55 PM
SolutionLet'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.
May 18 2021 02:54 PM
May 17 2021 02:55 PM
SolutionLet'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.