Cell Formatting: Red text if cell matches a certain condition, based on another cell

[medwardnfriends]

I have one column that contains a monetary amount (column AQ) , and another that contains text reading either "inflows" or "outflows" (column AC)

When AC says "inflows", AQ should be positive, and when AC says "Outflows", AQ should be negative.

I need the text in column AQ (the monetary amount) to become red when the the opposite is true.

i.e. When AQ is negative and AC says "Inflows", AQ should become red. And when AQ is positive and AC says "Outflows", AQ should become red.

Please let me know if anyone has a way of doing this via conditional formatting or vba. I would greatly appreciate it.

Thanks,
-Mark

 

[hemesh]

Hello martin, What if AQ is negative and cell AC populates with Inflow and AQ become red

 

[hemesh]

I have one column that contains a monetary amount (column AQ) , and another that contains text reading either "inflows" or "outflows" (column AC)

When AC says "inflows", AQ should be positive, and when AC says "Outflows", AQ should be negative.

I need the text in column AQ (the monetary amount) to become red when the the opposite is true.

i.e. When AQ is negative and AC says "Inflows", AQ should become red. And when AQ is positive and AC says "Outflows", AQ should become red.

Please let me know if anyone has a way of doing this via conditional formatting or vba. I would greatly appreciate it.

Thanks,
-Mark

I think when AC says Outflow and AQ is Positive AQ should become Green