Share via

Conditional formatting =if(Left)

Anonymous
2011-04-05T13:42:26+00:00

Hi there,

Can you do conditional formatting =IF(LEFT(B1:B3000,14)="Employee Group") in other words, if any text in column B have Employee Group 14 characthers in, Highlight the cell.  If it if possible I would also like to highlight the three cells to right as well.

Thanks!

Denise

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-04-05T14:08:34+00:00

Select all the column ranges to highlight first, then go to Format|Conditional Formatting and select Formula Is from the drop down and enter formula:

=LEFT($B1,14)="Employee Group"

This assumes you select from Row 1 downwards... Note: the formula will automatically update for the remaining rows in your selection.

Then click Format and choose colours from the Pattern tab

Was this answer helpful?

10+ people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-04-05T14:10:06+00:00

    Thank you!  I should have thought a little harder about that one......

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments