Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Conditional Formatting....or both? | Excel Worksheet Functions | |||
Stumped Conditional Formatting or Validation? | Excel Worksheet Functions | |||
Finding data validation and conditional formatting | Excel Discussion (Misc queries) | |||
Data Validation & Conditional Formatting | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) |