[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

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

Use different cells for conditional formatting on same row

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
John Desselle
Asked:
John Desselle
  • 2
  • 2
2 Solutions
 
RyanProject Engineer, ElectricalCommented:
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)

Open in new window


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
 
John DesselleAuthor Commented:
cool formula, but how would you use this to conditionally format the cells?
0
 
John DesselleAuthor Commented:
oh, I get it, the first entry in the list is just no formatting, then use the other three.  COOL
0
 
RyanProject Engineer, ElectricalCommented:
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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