Can I set up conditional formatting to do this?

[AndyFox42]

I'm designing a spreadsheet to review events for performance improvement tracking. I want to be able to enter the time of an event, and automatically have the spreadsheet indicate which shift (Day, Evening, or Night) was on duty when the event occured. I am wondering if I can use conditional formatting rules to automatically populate the cells in column D based on the contents of column C. Specifically, I want to enter a value in a cell in column C, and have D automatically populate with a specific word based on what the number in C is.

Example:

C5 contains "0830", D5 would populate with "Day"
C6 contains "1845", D6 would populate with "Eve"
C7 contains "2350", D7 would populate with "Night"

I would set it up with reference ranges (0700-1459 = day, 1500-2259 = Eve, 2300-2359 and 0000-0659 = Night.)

I can't seem to find a way to make this work. Any tips? Is this possible?

Thanks!

[Jonmo1]

No, conditional formatting can't put values in cells.
It can only apply Color or Borders or other cell formatting types.

You can use a formula in the cell itself then

Assuming the 0830 1845 2350 entries are TEXT strings,
in D5 put
=LOOKUP(C5,{"0000","0700","1500"},{"Night","Day","Eve"})