Forum Discussion
IF Statements with formulas
I will offer the observation that conditional formatting often takes trial and error, especially during the early learning phases of using Excel. I've used Excel for decades, literally, and still find myself sometimes struggling to get the conditional formatting rule (especially using formulas) to work.
This worked for me, using in K14 the same formula you have. Notice the conditional formatting formula is very simple. =(K14=L14) But notice there are no quotes around it in the conditional formatting rule. Getting rid of those is its own step sometimes.
It doesn't require the IF function, because all you're asking is "does K14 = L14"? so Excel evaluates that formula and returns 1 (true) if they are equal, and 0 (false) if they're not.
when I tried to apply it to my sheet, it still calls it false. Is it possible excel is just glitching?
Not likely. VERY unlikely in fact. Especially on some aspect that's been around as long as conditional formatting, it would be next to impossible that you have discovered a glitch in this routine. So let's look for what's going wrong.
Is it possible for you to post a copy of your spreadsheet on OneDrive or GoogleDrive, and paste a link here that grants access to it? So long as it doesn't have confidential info in it. If it does, maybe make a mockup that still illustrates the error.
- I figured out the issue, I had removed decimal places and so the numbers weren't actually the same
- https://lenapevalleychurch-my.sharepoint.com/:f:/g/personal/matthiasb_lenapevalleychurch_org/ElDAi-1Es9NOi8waIuZSkfoB1iaJq__7l5fEjTQIfp7yRQ?e=346Bfw