View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Krissy Krissy is offline
external usenet poster
 
Posts: 22
Default Conditional formatting and validation

Hi all
Quick help:
I have a worksheet were we enter a total number first , and then numbers
for different arguments.
For exmpl:
A B C D E F
Total Male Female Age40 Age41 Age42
12 7 5 6 4 2

etc.

As they are all entered manually, I'd like to have some sort of conditional
formatting in place if for A if A not=B+C or A not=D:F so the user can see if
the entered figures don't add up.

Any quick idea?