Using formula for conditional formatting [Closed]

Report
-
Posts
1927
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 17, 2021
-
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 reply

Posts
1927
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 17, 2021
143
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!