Solved

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

Posted on 2011-10-27
225 Views
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
Question by:Cluskitt

LVL 33

Accepted Solution

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

LVL 18

Author Closing Comment

Thanks!
0

## Featured Post

### Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.