I am trying to enter a formula for a new rule (shade every other row). I highlight the rows I want, click on Conditional Formatting and then New Rule. This box pops up and gives me nowhere to enter the formula. I haven't used this version of Excel before and don't understand how to proceed.
Screenshot 2023-10-18 at 12.27.52 PM.png
Last edited by Chrisgrey59; 10-18-2023 at 12:34 PM. Reason: Add image
The image is the only thing that pops up when i try to enter a new rule.
Last edited by Chrisgrey59; 10-18-2023 at 12:35 PM.
See the yellow banner for instructions for attaching files (including pictures).
Everyone who confuses correlation and causation ends up dead.
Yes, got that part finally, thank you!
where it says
>2 colour scale
click on that
and select
>classic
then
>only format cell.......
click on the dropdown
and select
>use a formula.......
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank you! That worked. Seems more complicated than the way I remember it. I don't know why they don't just make a button for that particular formatting...I feel like shading every other line is a pretty basic thing lots of folks want to do. But whatever, thank you. I will add to your reputation
you are welcome
may be a better way to do it , but thats how i do it
it would be worth updating profile to show 365 version 16.78
rather than just the release version
i also add its OSX , as on Mac OSX some windows features may not be available - although I think some are now , like power query
I got notification and a video emailed about a new excel feature - but only on windows versions , at moment , now has checkbox in the insert menu , where you can inset a checkbox and get TRUE, FALSE , not on my Mac version yet
Last edited by etaf; 10-18-2023 at 01:07 PM.
I imagine most people just format it as a table to get that effectOriginally Posted by Chrisgrey59
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks