Forum Discussion
creating a formula to highlight a cell based on another cell in the same row
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
Jella510 Tried to replicate your situation in the attached workbook. see if you can "transform" the CF rule to your schedule(s).
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:
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 Tried to replicate your situation in the attached workbook. see if you can "transform" the CF rule to your schedule(s).
