Would anyone happen to know why every time I go to one specific sheet in the Google Sheets/Excel workbook I'm working on, that particular sheet has all of its cells highlighted?
I'm guessing it's something simple I'm missing.
Every time I go to that one sheet, even if I click a cell to remove...
The problem is when i use a userform to transfer data to a worksheet that worksheet becomes highlighted. the problem is this started at row 54 and continues on the rest of worksheet as i add data from the userform this problem didnt happen in the previous 53 rows. What i have to do to get the...
I have a table in columns C - N. There are over 14000 rows of data. I need to have data where, in column K, there is data that is identical in consecutive rows. If I could have it highlighted then great, if I could have it automatically filtered out then even better! If filtering out is possible...
My data has account numbers and their corresponding $ value
Trying to add the $ value for those accounts which are not in the list in Column E
I.e. add column B except the items highlighted in grey
How best would you go about it?
I need to make certain cells on a report highlighted based on 2 conditions from raw data.
Basically what I need is:
If the date in range V2-V400 is today, AND the number in range Y2-Y400 is the same as say A2, then I need A2 to be highlighted.
I've been told by a colleague that...
I want to understand Developer-->Design mode and what is used for. I read this post
and Parry said: ""If you select the Control Toolbox to draw a control etc, you will notice that design mode automatically comes on.""...
Using Excel 2000</SPAN></SPAN>
I need to highlight all the reverse patterns of column C&D are find in the Columns E&F, G&H, I&J, K&L, M&N And in the O&P and want to be highlighted colours as shown in the example including C&D column... for Example C7:D7=2&1, reverse of it find...
I have a database with over 300 rows of data.
Data is populated through columns A:X
Is there a way to filter the rows so that only the rows highlighted a certain colour are filtered?
thanks in advance
HI every one,
i need a small logic if any one can help it will be very great full to me.
Hi all, this is probably easy for you guys
Using Excel for Mac
I have a spreadsheet, Columns A through E, many rows
Column E is called due date and has a date in it
Cell H1 is equals now command
If H1 is 1 or 2 days before the due date, I want that row from A to E to be highlighted yellow
In edit mode, when one letter is highlighted and left or right arrow key is pressed, usually, no letter is highlighted anymore. However, recently, I highlighted a letter, pressed an arrow key, and the next letter was highlighted. This is quite handy if I need to replace several letters in a...
i have 100,000 with about 15,000 lines that highlighted because there is a TRUE in and AND formula in the row.
I just filtered for TRUE< then highlighted in Yellow fill.
Now they want me to highlight the row immediately before the TRUE.
I can't seem to replicate my AND formula . .
This question is in reference to a calendar that keeps track of the 7 employees attendance. In my sheet, Cell AI20 is user entry of the first date. Cell AI21 is the user entry of the second date. Once the user enters the second date, the selected (dates) cells are highlighted...
I was kinda surprised I couldn't find a solution when I Googled this...
Let's say I have columns A through M. In Column C, I have various string values (let's say animals). Now, I want to highlight only those columns A through M when the value in column C is "Dog". I know I can do a For...
I would like to pull the condense of a cell on one work sheet and apply it to another sheet based on if it is highlighted with conditional formatting?
so if cells B5-B37 has a list of names and the cells have a conditional formatting of...
Is it possible to highlight duplicate cells in ROWS only whereby any text or numeric value is highlighted?
So in the below table
Row 1 - nothing highlighted
Row 2 - Cat highlighted
Row 3 = 555 highlighted (ignores 55)
Row 4 = Both Cat and 555 highlighted
If a person's row has a 5 in it, I'd like to have their cell highlighted red.
So the end result should have John's and Mike's cells highlighted red
I am trying to get my excel spreadsheet to highlight rows containing the word ‘June’ in column C1 when I have ticked my checkbox. I have my checkbox linked to cell N11 via conditional formatting so my formula at the moment is AND($C1=‘June’,$N$11)
However, this is returning (when my...
I need help. When I check a checkbox I want the text in listview to be highlighted in blue, I am having a problem where whenever I do check the checkbox the text does not highlight blue unless I move my cursor into the listview. Also whenever I check each individual checkbox in the listview...