Conditional Formatting for ISTEXT

%3CLINGO-SUB%20id%3D%22lingo-sub-1959723%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20for%20ISTEXT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959723%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20still%20new%20and%20learning%20to%20work%20with%20all%20of%20excels%20functions.%20Currently%2C%20I%20am%20trying%20to%20update%20a%20document%20at%20work%20so%20we%20do%20not%20have%20to%20manually%20change%20the%20colors%20of%20an%20entire%20line.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20highlighting%20the%20whole%20selected%20row%20and%20using%20a%20%3DISTEXT%20formula%20through%20conditional%20formatting.%20I%20then%20have%20been%20checking%20the%20specific%20cell%20I%20want%20to%20use%20for%20when%20text%20is%20entered%2C%20the%20entire%20row%20changes%20green.%20I%20have%20been%20having%20issues%20copying%20this%20format%20to%20multiple%20rows.%20I%20tried%20format%20painter%20and%20copy%20and%20dragging%20the%20formula.%20Any%20help%20would%20be%20appreciated%2C%20thank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEx%3A%20Row%2024%20is%20highlighted%20then%20conditional%20format%20using%20%22use%20which%20formula%20to%20determine%20which%20cells%20to%20format%22%20then%20enter%20%3DISTEXT(%24U%2424)%20and%20select%20the%20color.%20I%20am%20trying%20to%20get%20row%2025%20to%20go%20off%20of%20U25%2C%2026%20to%20U26%20and%20so%20on%20for%20the%20sheet.%20Each%20time%20I%20paint%20or%20copy%20it%20is%20makes%20all%20the%20rows%20go%20off%20of%20the%20original%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1959723%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1959745%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20for%20ISTEXT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959745%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F892309%22%20target%3D%22_blank%22%3E%40Kevinnn912%3C%2FA%3E%26nbsp%3BChange%20the%20CF%20formula%20to%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DISTEXT(%24U24)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eand%20it%20should%20work%20as%20desired.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1959771%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20for%20ISTEXT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959771%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Bthat%20worked%2C%20thank%20you%20for%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good morning,

 

I am still new and learning to work with all of excels functions. Currently, I am trying to update a document at work so we do not have to manually change the colors of an entire line.

 

I have been highlighting the whole selected row and using a =ISTEXT formula through conditional formatting. I then have been checking the specific cell I want to use for when text is entered, the entire row changes green. I have been having issues copying this format to multiple rows. I tried format painter and copy and dragging the formula. Any help would be appreciated, thank you!

 

Ex: Row 24 is highlighted then conditional format using "use which formula to determine which cells to format" then enter =ISTEXT($U$24) and select the color. I am trying to get row 25 to go off of U25, 26 to U26 and so on for the sheet. Each time I paint or copy it is makes all the rows go off of the original cell.

 

3 Replies

@Kevinnn912 Change the CF formula to:

=ISTEXT($U24)

and it should work as desired. 

@Riny_van_Eekelen that worked, thank you for the help!

@Kevinnn912 Glad it worked!