Conditional Formatting

[Ddio39]

Hello everyone this is my first post, I hope you can help. I have a project that I would like to conditionally format a row based on text in a cell that has text and numbers. For example a cell with IN25951, based on the IN the row would turn red. Anothe cell would have DL246936 that row would turn green. I can make the rows change based on IN or DL but when I add the numbers it doesn’t work. Am I trying to do the impossible? Thanks for any help. Dave

 

[JV0710]

Hi

For RED:
Assuming IN25951 is in cell A1 . . . . Conditional format formula =If(left(A1,2)="IN",1)

For Green:
Assuming DL246936 is in cell A2 . . . . Conditional format formula =If(left(A2,2)="DL",1)

 

[Ddio39]

Hi

For RED:
Assuming IN25951 is in cell A1 . . . . Conditional format formula =If(left(A1,2)="IN",1)

For Green:
Assuming DL246936 is in cell A2 . . . . Conditional format formula =If(left(A2,2)="DL",1)

Ok thanks, I am actually looking for data to be in F3 (it has IN and DL) with additional data on both sides.

 

[JV0710]

with additional data or just numbers on both sides ?

 

[JV0710]

If there are only numbers on either side if the "IN" or "DL", then

See pic for detail

 

[Ddio39]

If there are only numbers on either side if the "IN" or "DL", then

See pic for detail

Hi so it would be a combination of numbers dates and text.

 

[JV0710]

So what happens if the cell has data like --- IDLE46WINTER653IN543DL564IN122022 -- What should the colour be ?
In other words can you have "IN" or "DL" repeated in the Cell either on their own or as parts of words

 

[Ddio39]

So what happens if the cell has data like --- IDLE46WINTER653IN543DL564IN122022 -- What should the colour be ?
In other words can you have "IN" or "DL" repeated in the Cell either on their own or as parts of words

No the only cells that would contain DL or IN would be in column F.

 

[JV0710]

Please can you perhaps share an example or pic of your spreadsheet

 

[Ddio39]

I can't figure out how we to send spreadsheet, the columns are as follows begining on the left.
Regulation example 138.23
Date
Date completed
Name
Name
IN or DL example IN20220001566
Notes
Comments