SOLVED

creating a formula to highlight a cell based on another cell in the same row

%3CLINGO-SUB%20id%3D%22lingo-sub-2334864%22%20slang%3D%22en-US%22%3Ecreating%20a%20formula%20to%20highlight%20a%20cell%20based%20on%20another%20cell%20in%20the%20same%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2334864%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20highlight%20a%20cell%20based%20on%20another%20cell%20in%20the%20same%20row.%20with%20a%20specific%20word.%26nbsp%3B%20In%20this%20case%20'Overdue'.%26nbsp%3B%20can%20anyone%20help%20please%3F%26nbsp%3B%20I've%20been%20trying%20for%20about%20an%20hour.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2334864%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2335001%22%20slang%3D%22en-US%22%3ERe%3A%20creating%20a%20formula%20to%20highlight%20a%20cell%20based%20on%20another%20cell%20in%20the%20same%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335001%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047782%22%20target%3D%22_blank%22%3E%40Jella510%3C%2FA%3E%26nbsp%3BYou%20do%20this%20with%20Conditional%20Formatting.%20On%20the%20Home%20ribbon.%3C%2FP%3E%3CP%3ESelect%20the%20range%20of%20cell%20you%20want%20to%20format.%3C%2FP%3E%3CP%3EPress%20Conditional%20Formatting%3C%2FP%3E%3CP%3ENew%20rule%3C%2FP%3E%3CP%3ESelect%20%22Use%20a%20formula%20to%20determine%20which%20cells%20to%20format%22%3C%2FP%3E%3CP%3EEnter%20a%20formula%20like%3A%20%3DA1%3D%22Overdue%22%3C%2FP%3E%3CP%3Eand%20choose%20the%20format%20you%20want%20(fill%2C%20boarder%2C%20font%20colour)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20could%20look%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-05-07%20at%2013.08.24.png%22%20style%3D%22width%3A%20657px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279058iD326192681DF2A99%2Fimage-dimensions%2F657x250%3Fv%3Dv2%22%20width%3D%22657%22%20height%3D%22250%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-05-07%20at%2013.08.24.png%22%20alt%3D%22Screenshot%202021-05-07%20at%2013.08.24.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2335107%22%20slang%3D%22en-US%22%3ERe%3A%20creating%20a%20formula%20to%20highlight%20a%20cell%20based%20on%20another%20cell%20in%20the%20same%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335107%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047782%22%20target%3D%22_blank%22%3E%40Jella510%3C%2FA%3E%26nbsp%3BTried%20to%20replicate%20your%20situation%20in%20the%20attached%20workbook.%20see%20if%20you%20can%20%22transform%22%20the%20CF%20rule%20to%20your%20schedule(s).%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Good morning all,

 

I would like to highlight a cell based on another cell in the same row. with a specific word.  In this case 'Overdue'.  can anyone help please?  I've been trying for about an hour.  

Thanks in advance

3 Replies

@Jella510 You do this with Conditional Formatting. On the Home ribbon.

Select the range of cell you want to format.

Press Conditional Formatting

New rule

Select "Use a formula to determine which cells to format"

Enter a formula like: =A1="Overdue"

and choose the format you want (fill, boarder, font colour)

 

It could look like this:

Screenshot 2021-05-07 at 13.08.24.png

 

@Riny_van_Eekelen I can't get that to work.  I need the circled column to be able to turn yellow when the overdue title comes up.  The first cell is C8.  I'm not sure what I did wrong?

Jella510_0-1620387793051.png

 

best response confirmed by Jella510 (Occasional Contributor)
Solution

@Jella510 Tried to replicate your situation in the attached workbook. see if you can "transform" the CF rule to your schedule(s).