Need a comprobation

  • Thread starter Thread starter ileanardz
  • Start date Start date
I

ileanardz

I have this workbook with 3 sheets, Sheet1 has a table with amounts by
month, Sheet2 the same, and Sheet3 has the table 2 times with the
amounts by month.

I need to check if the amounts are the same in the 4 tables on the 3
sheets.

I would like a function IF that tell me if they are the same, are OK,
but if they are not the same some advertence with a color or
something.

Thanks!
 
I have this workbook with 3 sheets, Sheet1 has a table with amounts by
month, Sheet2 the same, and Sheet3 has the table 2 times with the
amounts by month.

I need to check if the amounts are the same in the 4 tables on the 3
sheets.

I would like a function IF that tell me if they are the same, are OK,
but if they are not the same some advertence with a color or
something.

Thanks!
Click to expand...

Use conditional formatting on sheet 1 with three conditions for each
cell - you can select three different "alarm" colours so that you know
where to look for any problem located.

A.
 
Back
Top