Time Conditional Formatting

[EmVella]

Hi,

When I paste time in excell I want that time later than 19:00 it becomes with a different color from other time (earlier than 19:00)

I want to paste as in Column A and then it comes automatically as Column C as the image below:
time excel.PNG

[Richard Buttrey]

Without a macro you can't paste into column A and have that also paste in column C. You could either paste into both columns or keep a formula in column C, i.e. C2: =A2

Then the conditional format in C2 copied down would be =C2>19/24

[EmVella]

Hi Richard,

If I paste for example in Column A I want that The time changes color in same row that is Column A.
Please ignore column C, Column C in the photo it is just an example how I want Column A to look like.

[JeteMc]

Try the following:
Select cells A2:A26
Using the following formula as the conditional formatting rule:

Please Login or Register  to view this content.

Select red font
Let us know if you have any questions.

[EmVella]

Hi JeteMc,

That is perfect and thanks very much!

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.