# How to apply conditional formatting across sheets

1. ## How to apply conditional formatting across sheets

xxxxxxxxxxxxxxxxxx

2. ## Re: How to apply conditional formatting across sheets

1st, pretty much none of your numbers are actually numbers/values, they are text that just looks like a number (just try adding 1 to them, in another cells). You will need to convert them/make them numbers

2nd, you cannot compare numbers (even after you have converted the text to numbers) to text - which is what you have on sheet2....<1

Where is this data coming from?

3. ## Re: How to apply conditional formatting across sheets

xxxxxxxxxxxxxxxxxx

4. ## Re: How to apply conditional formatting across sheets

Lets take this in stages...

1. make sure that all your headings match (eg make "Big Bold Red" = "Sea Big Bold Red")

2. are all your tests being done with the ranges in sheet2? (eg 60-120...38-43 etc) Again, this is text, and would need to somehow be converted to 2 seperate numbers for the comparison

This is what I have so far...
to find the value from sheet2...
=INDEX(SPECIFICATION!\$B\$7:\$E\$39,MATCH(PRODUCTS!C\$9,SPECIFICATION!\$A\$7:\$A\$39,0),MATCH(PRODUCTS!\$B10,SPECIFICATION!\$B\$6:\$E\$6,0))
(this is returning <1)
To convert the "number" in sheet1 to a real number...
=--SUBSTITUTE(C10,",",".")

Here is where I am trying to head.

lets say that Spec sheet A16 was DO, instead of A17, then to do the CF, I would use this formula...
=INDEX(SPECIFICATION!\$B\$7:\$E\$39,MATCH(PRODUCTS!C\$9,SPECIFICATION!\$A\$7:\$A\$39,0),MATCH(PRODUCTS!\$B10,SPECIFICATION!\$B\$6:\$E\$6,0))<--SUBSTITUTE(C10,",",".")

xxxxxxxxxxxx

6. ## Re: How to apply conditional formatting across sheets

2. Yes SPECIFICATION sheet is the reference ranges for the test.
yes, I got that

What I meant was - are you testing (where applicable) against cells containg ranges like 60-120 or 38-43. As I said, these are text entries. Would it be possible to split those into 2 seperate cells/columns? In other words, each category in the Spec sheet will have 2 columns

xxxxxxxxxxxx

xxxxxxxxxxx

xxxxxxxxxxxx

xxxxxxxxxxxx

11. ## Re: How to apply conditional formatting across sheets

xxxxxxxxxxx

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1