Hello All,
I'm looking for a formula for Condition Format when Cell Value = "0" (zero) but not applied for BLANK
Regards,
tt3
Hello All,
I'm looking for a formula for Condition Format when Cell Value = "0" (zero) but not applied for BLANK
Regards,
tt3
Last edited by tuongtu3; 11-21-2015 at 09:41 PM. Reason: Solved
maybe this....
=A1=0
If this does not work for you, can you give some more details and maybe a sample of what you are working with, and what you want?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try
=AND(A1=0,A1<>"")
Hi,
I used that one but did not work.
Regards,
tt3
Hi,
Two of them did not work. I want Range H15:H515 turn RED when their value = 0 but no RED if cell is BLANK
Regards,
tt3
Change the A1 references to H15
=AND(H15=0,H15<>"")
is the cell actually blank - as in there is nothing in it? Or does it contain a formula?
upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
Jonmo's suggestion (better than mine), should work?
Please checl sample attached cell H15:H25. Cell is blank (no formula) then user enter value into it.
Regards,
tt3
You have to use the option "Use a formula to determine which cells to format" when creating a new rule.
And use the formula
=AND(H15=0,H15<>"")
@FDibbins & Jonmo1: Thank you very much for your help.
Regards,
tt3
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks