Searching exact 4 values in any cells in same row then change 4th value to 5th value

[tuongtu3]

Hello All,
I'm doing manually to update all reports. Is it possible to searching the exact 4 values in same row to the last row within a worksheet, if 4 exact values was found then change the fourth value to 5th values (Please note that the values could be at any cells in the same row)

First Second Third Fourth

Let says: if 4 values was found then change "Fourth" to "Fifth"


Regards,
tt3