Conditional formatting and validation
Use a formula to set the condition:
=A2<(B2+C2)
and set that color to red (or whatever)
Set a second condition
=A2<(D2+E2+F2)
and set that color to yellow
Format painter should work down the blank cells in column A because you
entered the conditional format with relative references. If the first
condition is met, then the second condition is not checked. If there are no
problems, there should be no formats on the cell in column A.
"Krissy" wrote:
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?
|