SOLVED

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

Copper 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 (Copper Contributor)
Solution

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

1 best response

Accepted Solutions
best response confirmed by Jella510 (Copper Contributor)
Solution

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

View solution in original post