Using formula for conditional formatting

Closed
Richard - May 12, 2016 at 09:28 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - May 12, 2016 at 09:37 AM
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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
May 12, 2016 at 09:37 AM
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.
0