Using formula for conditional formatting

Closed
Richard - 12 May 2016 à 09:28
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 12 May 2016 à 09:37
Hello,

Excel 2013
I need to add an if formula that creates conditional formatting and I get the basics of it but my formula is not working
It's a financial ledger where column B is where cheque # are typed
I want column H to highlight if there is a cheque # in B
Then I want the Highlight to go away if I type any text in H
This way I know there are cheques I have not reconciled

I'm using this formula under the conditional formatting and it's not working
=IF($B5<>"",$H5)

Thanks!



1 response

Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
12 May 2016 à 09:37
Richard, Good morning.

Try to use:

Select H5

Conditional Formating:
Formula:
=AND(B5<>" ";B5>0)

Choose the color you want.

Please, tell us if it worked for you.
I hope it helps.