May 07 2021 03:24 AM
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
May 07 2021 04:10 AM
@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:
May 07 2021 04:44 AM
@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?
May 07 2021 05:20 AM
Solution@Jella510 Tried to replicate your situation in the attached workbook. see if you can "transform" the CF rule to your schedule(s).
May 07 2021 05:20 AM
Solution@Jella510 Tried to replicate your situation in the attached workbook. see if you can "transform" the CF rule to your schedule(s).