Conditional Formatting or a Formula I think?
 

Hi There,

I have 7 sheets in a workbook, all the sheets are identical, the only
exception is that all the sheets feed into sheet 1. The data on all the
sheets is within the following range B2:K40.
Sheet 1 shows the highest number in each cell (B2:K40) which comes from the
feeder sheets. The problem i have is that rather than scrolling through all
the feeder sheets to see what sheet produced the highest value (sometimes 2
or even 3 sheets have the same highest value) i would like a conditional
format or code to tell me, where the highest value came from.

thanks for your help

Big H

Conditional Formatting or a Formula I think?
 

conditional formatting will only support 3 different formats.

quick workaround would add 3 columns next to your values and set conditions
to compare value to sheets 3 in firts col, 3 in next col and 1 in 3rd col
if(val=Sheet1!value) "Sheet 1"

"Big H" wrote:

Hi There,

I have 7 sheets in a workbook, all the sheets are identical, the only
exception is that all the sheets feed into sheet 1. The data on all the
sheets is within the following range B2:K40.
Sheet 1 shows the highest number in each cell (B2:K40) which comes from the
feeder sheets. The problem i have is that rather than scrolling through all
the feeder sheets to see what sheet produced the highest value (sometimes 2
or even 3 sheets have the same highest value) i would like a conditional
format or code to tell me, where the highest value came from.

thanks for your help

Big H