• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 107
  • Last Modified:

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
0
Seamus2626
Asked:
Seamus2626
  • 2
2 Solutions
 
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
 
Haris DjulicCommented:
Here is the file...

For the equal values i Used the Round..
EE.xlsx
0
 
QlemoC++ DeveloperCommented:
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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now