Compare number and color cell if biger or smaller

[besmir]

Hello

I have my hourly work file and i want to color cells with red if the number is biger than colum E and green if is smaller. i do il manually but i wanted to know that if can be auto fill every time i write the numbers. Oh but also can allow me to ad employers at Max 200 names.

Thank you here is the example.

[Pauleyb]

Why, in your original file is cell K5 green? Shouldn't it be red? Why are cells S3 and S4 bright red?

Using conditional formatting, this should solve the problem as stated.
Highlight your range (F2:AF245)
Hit Conditional Formatting
Say you want to use a formula
Type in this formula:
=AND(NOT(ISBLANK(F2)),$E2>F2)
and then format it as a red background
Add another rule with this formula
=AND(NOT(ISBLANK(F2)),$E2<F2)
and format as green background

I did not include an attachment, since when I tried to save the file it said it had active x control code or web extensions. Not sure what is up with your file, but it was too suspicious for me to upload.

[besmir]

I dont know what was the prob with the download but the answer was very helpfull

Thnx a lot

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.