Conditional formatting not working MS 365, Windows 10, PC

Question

Good day,Am trying to replicate what is shown on youtube&nbsp;https://www.youtube.com/watch?v=kJFLnviz8jc&amp;list=PLpsGVOobEOlBS94rI7L6FlzyUhAXrlbxHat 29min 40 secondI keep getting &lt;something wrong with the formula)&nbsp;Any suggestions? I have updated windows,&nbsp;Excel version 2211 (build 15831.20208)=and($b3&lt;&gt;"",isodd(row()))&nbsp;

mathetes · Answer

pgg1507&nbsp;&nbsp;Main suggestion: Watch that video more closely. &nbsp;Granted, it's moving fast, and this stuff can be confusing, given the terminology overlaps. But, just so you know what to be watching for, it is&nbsp;NOT using Conditional Formatting. So all your efforts in the Conditional Formatting rules are misplaced.&nbsp;It's using the area on the home tool bar for formatting of numbers, and they've gone down to the bottom of that list of options, selected "More number options"&nbsp;and then &nbsp;again to the bottom to create a custom version&nbsp;&nbsp;&nbsp;

pgg1507 · Answer

mathetes&nbsp;Thanks but I've watched this part over 20 times, he clearly states &lt;Conditional Formatting&gt;I just noticed a small difference see red arrow, my version of Excel shows an Arrow pointing up, it only closes the New formatting window, only leaving a small window showing the lower part of the window.&nbsp;Still having this issue 😞&nbsp;

mathetes · Answer

Am trying to replicate what is shown on youtube ... &nbsp;at 29min 40 second&nbsp;Sorry, I was watching at 2 minutes 40 seconds, which was not conditional.But the video ENDS at 29 minutes.And I'm not really interested in watching more YouTube. Can you describe what you want the formatting to be in your own words. And ideally provide a copy of the workbook you're working with so we can work on that WITH you. Post a copy on OneDrive or Google Drive, paste a link here that grants edit access to it. That way folks here can work with the actual, and work to accomplish the results you want.I will say, that even though I use Conditional Formatting extensively, it often is elusive; I find I need to do a lot of trial and error, not always, but often enough...... So be patient with yourself.But please, don't send us to watch a video and say you want that, without giving us the ability to see your actual workbook and work on it. Otherwise, the best we could say is "Follow what that video says." We can not possibly know what it is that you're doing that fails, since we don't see what you've done, what you're working with, and so forth.Help us help you.

pgg1507 · Answer

mathetes&nbsp;Thank you so much for your assistance, here's a link to OneDrive see Employee Database, tab bottomhttps://1drv.ms/x/s!Al7jijM2y6HHqla3YgGPdKQ1ygoa?e=8R5zIKAm trying to format cells B3 to F20 (as an example)Odd rows one color, Even rows a different color.=and($E3&lt;&gt;"",ISEVEN(row()))format Red=and($E3&lt;&gt;"",ISODD(row()))format yellow😉&nbsp;&nbsp;&nbsp;

mathetes · Answer

pgg1507&nbsp;Am trying to format cells B3 to F20 (as an example)Odd rows one color, Even rows a different color.&nbsp;If what you're really trying to do is just format odd rows one color, even rows a different color--and those colors are not in and of themselves important--there's a VERY SIMPLE way to do it.&nbsp;On the Home toolbar, right next to conditional formatting, there's a box labelled "Format as Table" and when you highlight the area in question, and select that box, you get a host of optional formats, each of which involves alternating colors on the odd and even lines.And a single click yields this kind of thing, as one example.That said, if you really want to use Conditional Formatting, even though it's utterly unnecessary, your formulas were perfectly fine. I don't know what you were doing that caused them not to work; perhaps not highlighting the relevant cells to which the rules should apply. See the attached.&nbsp;&nbsp;

Forum Discussion

Conditional formatting not working MS 365, Windows 10, PC

8 Replies

Resources