Conditional formatting

Hi,

Attached is a spreadsheet where i need a condtional formatting rule in range S7-S72 stipulating

If T7 is > S7 then Green, if T7 = S7, then amber & if T7 < S7 then red

Many thanks
EE.xlsx
Seamus2626Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Please find attached one solution.
EE.xlsx
0
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
However, your question as stated does not make sense.

1. There are no values in T7.
2. S7 is a small integer - it is generally not comparable with U7 anyway.

Therefore, I have used U7 and Q7 instead of T7 and S7. Please have a look at it and let me know if I have interpreted your request correctly.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Haris DulicCommented:
Here is the file...

For the equal values i Used the Round..
EE.xlsx
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
S7 is no integer but a float, but nevertheless it makes it "difficult" to compare for exact "S7 = T7" - that will likely never happen.

Further, the extensive usage of merged cells is unnecessary here. I would just have resized the row height instead, and used single, unmerged cells.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.