Highlight a value already Highlighted at another sheet

[nburaq]

Hi Gents,
I have a sheet called "Orders" and all order numbers are in column A and estimated costs are in column B and actual costs are in column C. I already used a formula to highlight values in Orders sheet as C>B.
On the other hand, I have another sheet called "Materials" and same order numbers are also used in this sheet. My aim is to highlight order values in "Materials" sheet which are already highlighted in "Orders" sheet. Is there any way to do it? Thanks for your help and concern.

 

[nburaq]

Is it possible to use countif function? I got stuck

 

[Kenneth Hobson]

Use another condition format? If the same relative cells are not in that sheet, reference the sheet in your format formula. e.g.

=if(Sheet1!$A$1>5

 

[nburaq]

Use another condition format? If the same relative cells are not in that sheet, reference the sheet in your format formula. e.g.

=if(Sheet1!$A$1>5

Thanks for the help but I already used formula =$S>$R2 for conditional formatting in Sheet1 to highlight the values I want to see and I want to highlight the same values in Sheet2 already highlighted in Sheet1.

 

[Kenneth Hobson]

I could show you how to do it with a macro but I recommend the conditional format as I explained in #3.

Like any formula entry, as you enter the formula, you can select the cell(s) in the other sheet and the full reference will be added. Or, just copy your formula but add the sheet reference. Since I don't know what your sheet names are, I can do that for you. I just gave you a generic example.

 

[nburaq]

Hi Kenneth,
I tried the solution you explained me in #3 but interestingly it does not highlight all the same values based on sheet1 but works partly. I think I will use an helper column and I will use that column for sheet2. Thanks again your help!

 

[Kenneth Hobson]

When I tried it, it marked the corresponding row. The row numbers are expected to be the same. It does not depend on the values in that sheet2. e.g. Sheet1's S4=5 and and R4=3. Then in Sheet2 say column K then K4 is formatted. I can share a link to see how I did it if that interests you.

 

[nburaq]

When I tried it, it marked the corresponding row. The row numbers are expected to be the same. It does not depend on the values in that sheet2. e.g. Sheet1's S4=5 and and R4=3. Then in Sheet2 say column K then K4 is formatted. I can share a link to see how I did it if that interests you.

That would be awesome! Thanks for our help!