I need to highlight all of the cells in a worksheet that are greater than 100 characters, the highlight color doesn't matter. Does anyone have a simple formula or VBA macro to do this? Thanks in advance!
I need to highlight all of the cells in a worksheet that are greater than 100 characters, the highlight color doesn't matter. Does anyone have a simple formula or VBA macro to do this? Thanks in advance!
Try this - it will mark the cells yellow.
Please click the * below if this helpsPlease Login or Register to view this content.
Please click the * below if this helps
That did the trick, thanks JasperD, have clicked the * for you.
Yes you can do this with conditional formatting. highlight the first cell you want to format, and go to conditional formatting. Make a new Rule. choose use a formula to determine which cells to format. in the format values where this formula is true type this formula
This assumes you have chosen A1
=IF(LEN(A1)>100,TRUE,FALSE)
Then copy only formating to all other cells you would like to format
Regards,
amotto
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks