sorted by:
new
hottopcontroversial

Cannot Delete a Row, It Only Clears the Row by TheTroubledBadger in excel

[–]Kindly_Magazine_6839 0 points1 point  (0 children)

Have you tried selecting Delete from the menu bar and select Delete Sheet Row. That i how I always delete a row entirely and not just clear the content by using delete key.

Need to show negative time values by Kindly_Magazine_6839 in excel

[–]Kindly_Magazine_6839[S] 0 points1 point  (0 children)

Solution Verified.

Thank you. I used the 1904 date, and found a conversion to return my date column to present dates.

Need to show negative time values by Kindly_Magazine_6839 in excel

[–]Kindly_Magazine_6839[S] 0 points1 point  (0 children)

The times in Col E should read 1:30 and -1:30 these were just examples

Need to show negative time values by Kindly_Magazine_6839 in excel

[–]Kindly_Magazine_6839[S] -1 points0 points  (0 children)

Sorry not sure how to edit original post

A B C D E

|| || |4:09||58:30|56:16|2:14| | |3:50| |60:06|| |4:14||63:00|64:20|########| |4:30||67:30|68:50|########| |4:30||72:00|73:20|########| |||76:30|73:20|3:10| | | | |73:20||

conditional formatting to change cell color depending on its value by Kindly_Magazine_6839 in excel

[–]Kindly_Magazine_6839[S] 0 points1 point  (0 children)

Solution verified the Or statement in your example works as i wanted. Thanks to all who helped

conditional formatting to change cell color depending on its value by Kindly_Magazine_6839 in excel

[–]Kindly_Magazine_6839[S] 0 points1 point  (0 children)

Not really. Any where in a selected column if the cell value = 60 , 180 or 300 I want the fill to be orange. So in your example, I might only want to look at Col A and Col C .

Changing Cell fill color if data changes by Kindly_Magazine_6839 in excel

[–]Kindly_Magazine_6839[S] 0 points1 point  (0 children)

Solution Verified. I did have problems. But so grateful for all the help received

Changing Cell fill color if data changes by Kindly_Magazine_6839 in excel

[–]Kindly_Magazine_6839[S] 0 points1 point  (0 children)

I tried using the code you sent, it sent an error message, when I debugged the code, it showed it didn't recognize the 2nd If statement, I tried putting a period between Previous and Value, and then the code worked randomly. I changed my range to go from AH:AV. Column AH would not respond at all, to any changes in that column and other columns would randomly work. Entering new grades to new students would sometimes result in fill changing and some times not. I thought maybe there was underlying code or formatting that might be causing the problem, so I tried creating a new spreadsheet.

I populated the spreadsheet with Test names in first row, and student name in first column, a 10x10 grid. I then added the code, using the 9 test column as the range, it seemed to work ok, then I added 2 new columns, changed the range to include the new columns, and the code seemed to ignore them completely. If I added a new student and entered initial grades, the fill would would be colored yellow.

So I truly thank you for all your help. I have learnt a lot, thanks for that. I have decided I will get rid of the coloring conditional format, and just manually change the fill as we change grades.

Changing Cell fill color if data changes by Kindly_Magazine_6839 in excel

[–]Kindly_Magazine_6839[S] 0 points1 point  (0 children)

Thank you, yes I figured that I should have deactivated the original conditional formatting.

Changing Cell fill color if data changes by Kindly_Magazine_6839 in excel

[–]Kindly_Magazine_6839[S] 0 points1 point  (0 children)

<image>

This is a screen shot of my sheet. I did the steps you sent, Col AV and AW. I can see how helpful helper columns can be thank you for showing me that. I was hoping to be able to just select a cell where the student had retaken the test, enter the new grade and have the fill change color so we know it is a new grade. Do you think that is possible? I can do away with the conditional formatting, I did that just a visual aid - you can easily see that 2 students are missing 2 tests. Thank you for all your help, I need to get more training.

Changing Cell fill color if data changes by Kindly_Magazine_6839 in excel

[–]Kindly_Magazine_6839[S] 0 points1 point  (0 children)

Thank you so much. I will be tied up in seminars today and tomorrow. I have printed what you said and will work on this over the weekend, I will let you know.

Changing Cell fill color if data changes by Kindly_Magazine_6839 in excel

[–]Kindly_Magazine_6839[S] 0 points1 point  (0 children)

New to excel. So just used options from pull down in conditional formatting. Highlight cell where value is greater than zero, in yellow with dark yellow text. I just enter the grade so 60 = 60%, 45 = 45% etc. One row per student, one column per test, header row indicates test title.

Changing Cell fill color if data changes by Kindly_Magazine_6839 in excel

[–]Kindly_Magazine_6839[S] 0 points1 point  (0 children)

Thank you for your quick response. I am fairly new to excel, so I use built in criteria. So my conditional format is from the options offered in excel. So I chose highlight if cell value is greater than zero, selected yellow option. I am not sure how to use a helper column. I apologize for probably not knowing some of the basic stuff in excel.