Row hight Conditionaly

[maftoun]

I have report and actual date of a transaction. I want row auto highlight when I enter actual date of transaction, and get off when I enter repot date of transaction. Could you please help me?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Thanks

 

[dave3009]

Sure where are these dates entered, you should be able to use Conditional Formatting.

 

[lenze]

Assuming Column "A" for 1st date and Column "B" for the 2nd.
Select your Row(s) of interest. In CF, choose "Formula Is"

=$A1*NOT($B1)

Format as desird

lenze

 

[maftoun]

Thanks, Column A and C, The goal is show me pending transaction. I want also say Pending when one date is entered. When i have both date enter pending and hight disappear.

Lanze formula work, but when I use IF condition pending show but hight will turn off

Thanks for your help.

 

[maftoun]

Thanks Lanze, It works. I did not realize that I want also say pending in 2nd cell Date. when i enter date hight and pending disapper

It may be I need a macro,

Thank you for you help

 

[lenze]

What Columns are your dates in??
What Column(s0 do you want 'Pending' to appear in??

lenze

 

[maftoun]

Column A is date from budget report. Column C is actual transaction date. I want pending show on Column A when I enter Date and turn off Hight

Thanks for your help

 

[lenze]

So if you enter a date in "C", you want "A" to say Pending and be highlighted?
You are confusing me!!
lenze

 

[maftoun]

Sorry for confusion. Lat me if I can explain better


Budget report date Store Acual buy date Amount
July-10 Officemax 6/15/210 40.00
Pending Office max 7/24/210 10.00

 

[maftoun]

Sorry


Budget report date Store Actual buy date Amount
July-10 Office max 6/15/210 40.00
Pending Office max 7/24/210 10.00

Report comes 1 month later at least.

Report come later, but i have invoice date I can enter it in C, When I enter date in C I want row be hight light and A said Pending

When I enter Report date On A, row hight light should turn off.