Conditional Formatting for Closing Bank Balance

[Neilesh Kumar]

Hi Guys,

Can you please help me on my thread. I want to put condition formatting for the Actual Vs. Budgeted Closing Bank Balances in the annexed format sheet, so would like to request to you please help me on the same.

Regards,

Neilesh

[Special-K]

Condtional Formatting works by formatting cells under specified conditions.
You haven't specified any conditions...

[Neilesh Kumar]

Sir,

In case of Positive Actual closing Balance if it is less than the Budgeted then it should be red. But in case of Negative if it is less then the budgeted then it should be green.

[Neilesh Kumar]

Sir,

In case of Positive Actual closing Balance if it is less than the Budgeted then it should be red. But in case of Negative if it is less then the budgeted then it should be green.

[Neilesh Kumar]

and the Condition i want to apply on the difference column.

[Neilesh Kumar]

Hi Sir,

Can you please help me on my thread. I want to put conditional formatting for the Actual Vs. Budgeted Closing Bank Balances in the annexed format sheet, so would like to request to you please help me on the same.

In case of Positive Closing Balances, If Actual closing Balance if is less than the Budgeted then the Difference column should be red. But in case of Negative Closing Balances, if it is less then the budgeted then the Difference should be green and the Condition i want to apply on the difference column.


Regards,

Neilesh

[Special-K]

Try this

Select I8

Conditional Formatting
New Rule
Use a formula to determine...
2 rules required

=(AND(G8<E8,SIGN(E8)<>-1))
format as red

=(AND(G8<E8,SIGN(E8)=-1))
format as green

Use Format painter (paintbrush icon) to copy to other cells

[Neilesh Kumar]

Hi Sir,

Only the first formula is working and not the second one. Can you please look into the same?

Regards,

Neilesh

[oeldere]

Hi Sir,

Can you please help me on the my thread?

http://www.excelforum.com/showthread...56#post4416256

Regards,

Neilesh

Please do not PM me, this is a question for the excel forum.

[Special-K]

Try these instead

=(AND(G8<E8,SIGN(G8)<>-1))
format as red

=(AND(G8<E8,SIGN(G8)=-1))
format as green

[Neilesh Kumar]

Thank you so much Sir. By using the latest formula it's working. Thank you so much once again.