[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

Applying conditionl format (lowest value) to the more columns in the row

I have a conditional format rule that paints the cell in range D1:D9 with the lowest value. I want to maintain this rule, but paint A to D of that row. So far, I've been unsuccessful. A little help, please?
0
Cluskitt
Asked:
Cluskitt
1 Solution
 
NorieCommented:
So you want to apply the format to columns A-D of the row with the lowest value in D?

Select the whole range (A1:D9?) and use this formula.

=MIN($D$1:$D$9)=$D1
0
 
CluskittAuthor Commented:
Thanks!
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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