Conditional format order priority

J

Joe M.

I have conditional format on a row where the row turns green upon the value
of a cell in the row. I have another where a particular cell turns orange
based upon a value in the same cell.
For row: =$J10="CLSD" format green
For cell: =$K10="Y" format orange
My problem is that when J10="CLSD" row 10 is green but cell K10 is only
orange if K10="Y" and J10 <> "CLSD". When J10="CLSD" then K10 is also green
regardless of the value of K10. I would like cell K10 to be orange even when
the row is green. The row cond format seems to be taking priority over the
cell cond format. Can anyone help?

Thanks,
Joe M.
 
S

Sandy Mann

Won't simply reversing the order do what you want?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
J

JE McGimpsey

Once one CF is evaluated as true, then XL displays the CF and doesn't
look at any "higher" numbered conditions.

One way:

For all cells, except column K, use your row CF.

For column K:

CF1: =$K10="Y"
Format1: <orange>

CF2: =$J10="CLSD"
Format2 <green>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top