Conditional formatting random text

[mrkasten]

I need to have an entire row highlight red when text has been entered into column 'AB'. The problem I am running into is that the text will never be the same because it is an address. I can get the cell to turn red by using the unigue conditional formatting. I already have a macro running on this page so if that is the only way i will need help adding the new code to my exciting code.

Thanks for any future help

 

[Joe4]

How about just checking the length of the entry in AB to see if it is greater than zero?, i.e.:

=LEN($AB1)>0

 

[mrkasten]

That works perfectly minus the fact that it also fills the column headers. For the selected data i have to select the entire table because large chunks of new data gets added each month and i never know how far down it will go

 

[mrkasten]

Never mind i just figured it out by switching the $AB1 to $AB2(something simple i should of caught the first time).

Thank you so much for the help and quick response

 

[Joe4]

That works perfectly minus the fact that it also fills the column headers. For the selected data i have to select the entire table because large chunks of new data gets added each month and i never know how far down it will go

If there is some way to differentiate the file headers from the data (i.e. they always start a certain way, etc), you can incorporate that into the Conditional Formatting Logic. For example, let's say the header always says "Header". Then you could use:

=AND(LEN($AB1>0),$AB1<>"Header")

 

[mrkasten]

wait that didnt work either because that would highlight the cell above the new entry

 

[mrkasten]

If there is some way to differentiate the file headers from the data (i.e. they always start a certain way, etc), you can incorporate that into the Conditional Formatting Logic. For example, let's say the header always says "Header". Then you could use:

=AND(LEN($AB1>0),$AB1<>"Header")

this filled everything

 

[Joe4]

this filled everything

Please post the exact formula you are trying, a small sample of what might be in column AB and indicate which ones should be highlighted and which ones shouldn't. Then I can try to re-create your exact layout.

 

[mrkasten]

=LEN($AB1)>0

an example what will be put in the cells is:
300 Cambridge Dr./Murray, IL 43212

 

[Joe4]

You said that it filled everything though.
What are some examples of entries in AB that you do not want highlighted?
Is there a common thread to these entries you don't want highlighted (how can we identify them from the data you do want highlighted)?