Solved

# Use different cells for conditional formatting on same row

Posted on 2012-08-17
360 Views
In a cell I have a drop down list of either Yes, No or ? (C2).  Depending on which of these is chosen, that entire row is highlighted a different color.  (I only used two conditional formatting for this because 'NO FILL' is a color too, white)  I want to be able to also look at cell F2 and if it = YES, I want that entire row to be bold.

Trouble is, that if cell C2 = No and the row turns grey, AND cell F2 = Yes, nothing happens for that condition.  It is like conditional format can only do one format per row.
BundlesForImage.xls
0
Question by:John Desselle

LVL 13

Assisted Solution

Yes, only 1 condition can be met. I see 4 test cases, it'll use which ever one tests true first.

What you can do is over in col J use the following formula
``````=IF(C2="yes",1,0)+IF(F2="yes",2,0)
``````

IF val=0 then not grey or bold.
if val = 1 then grey not bold
if val=2 then not grey but bold
if val=3 then grey and bold

You can then either hide that column, or set its forecolor to be white to effectively hide it.
0

Author Comment

cool formula, but how would you use this to conditionally format the cells?
0

Author Comment

oh, I get it, the first entry in the list is just no formatting, then use the other three.  COOL
0

LVL 13

Accepted Solution

Actually, yes thats true.  You can leave the first conditional off, as it would be default. Check for 1,2 and 3.
0

## Featured Post

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.