Hi all,
I'm struggling to phrase a conditional formatting formula correctly and i hope someone can help.
I'd like to apply the formatting to column K based on the value on the same row in column D i.e. If D2 = "Complete" then K2 is green...
A lot of the example use a static comparison but i need it to be dynamic and per row...
Any help would be appreciated!
I'm struggling to phrase a conditional formatting formula correctly and i hope someone can help.
I'd like to apply the formatting to column K based on the value on the same row in column D i.e. If D2 = "Complete" then K2 is green...
A lot of the example use a static comparison but i need it to be dynamic and per row...
Any help would be appreciated!