Highlight the cell
Closed
stephen
-
Jun 25, 2010 at 07:04 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 26, 2010 at 07:29 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 26, 2010 at 07:29 AM
Related:
- Highlight the cell
- Folder highlight - Download - Customization
- Clear only the formatting from the selected cell (leaving the content) - Guide
- If cell contains date then return value ✓ - Office Software Forum
- Based on the cell values in cells b77 - Excel Forum
- Which example represents cell data with the date format applied to it? - Excel Forum
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 25, 2010 at 03:54 PM
Jun 25, 2010 at 03:54 PM
What do you mean by highlight if name is not sorted. As soon as first name is not sorted, then other names are out of sort. Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
i had attached the sample in the following link to help more.
http://www.editgrid.com/explore/user/stephenraj2001/sample
http://www.editgrid.com/explore/user/stephenraj2001/sample
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 26, 2010 at 07:29 AM
Jun 26, 2010 at 07:29 AM
You can use conditional formatting for this
As per your sample book, you want to highlight based on data in column C
Select from C2 all the way down to the last cell
Then go to conditional format
enter this formula
=AND(AND(ROW(C2)>1, C2<>""), OR(AND(C2>C3, C3<>""),AND(C1>C2, C1<>"")))
and then click on the format function and choose color yellow
As per your sample book, you want to highlight based on data in column C
Select from C2 all the way down to the last cell
Then go to conditional format
enter this formula
=AND(AND(ROW(C2)>1, C2<>""), OR(AND(C2>C3, C3<>""),AND(C1>C2, C1<>"")))
and then click on the format function and choose color yellow
