Conditional Formatting Not Working With Formula
Hi Guys,
I'm trying to Format cells depending on dates in another cell. I'm using a Formula for the Formatting, but even though the formula returns as true the cell is not formatted. I've tried to make sure that all the dates are dates and not text. I just can't work out why it won't format if the formula is TRUE.
Un tick Check Box in Conditional format Pane
"Stop IF True"
Punnam
Hi,
You have the formula =IF(D19=B30,"") in cell A33, D19 & B30 both equals 28/08/2014. The formula returns blank ("") when the conditions match. If you want to change the output to TRUE when the criteria match change the formula as following:
=IF(D19=B30,"TRUE","")
& the conditional formatting formula in the same cell to (A33) :
=D19=B30
For conditional formatting you need a formula that returns True or False instead of a value like in case if IF formula. So for conditional formatting your col. O change the formula used for conditional formatting to this.....
Does this help?
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thanks sktneer that works a charm.
Last edited by markd038; 08-28-2014 at 03:50 AM.
What made no difference?
You're welcome. Thanks for the feedback.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks