Using formula for conditional formatting

Closed
Report
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 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
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
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.