Value of one cell impacting another

[Kmartin83]

Hi there,

I am new to conditional formatting and have been helped greatly earlier in the week; am hoping someone out there can help me again!

I have two columns: AO (titled: Days alcohol consumed) and AP (titled: Units per day)
I need to cross reference these columns and hightlight errors.

E.g., if a client has listed that they drink for 14 days (column AO) they should also have a value (greater than 0) in column AP. Note: Column AO can have a value of 0-28, column AP can have 0-200.

I also then need this in reverse, e.g., if a client listed that they drink 20 units per day (column AP) then there must be a value in column AO.

Errors would need to be highlighted

Any guidance would be greatly appreciated!
Thanks,
K

[Kaper]

Try selecting all your data range (say AO2:AP100) and in your conditional formatting rule (Conditional formattin-> new rule-> using formula...) use something like:

Please Login or Register  to view this content.

and use the formatting you like.

if for no_dose or no_drinking there are zeroes not blank cells - use this instead:

Please Login or Register  to view this content.

[Tony Valko]

Try this...

Let's assume the range of interest is AO2:AP10

Select the *entire* range AO2:AP10 starting from cell AO2.
Cell AO2 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Goto the menu Format>Conditional Formatting

Select the Formula Is option

Enter this formula in the box on the right:

=COUNTIF($AO2:$AP2,">0")=1

Click the Format button
Select the Patterns tab
Select the desired fill color
Select the desired style(s)
OK out

[Kmartin83]

Works brilliantly! Thanks!

[Tony Valko]

You're welcome. We appreciate the feedback!