User Profile
chwar750
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
- 3.2KViews0likes1Comment
Re: Conditional Formatting exception formula
Hi NikolinoDE, I have managed to vary your formula which you provided to the original poster for my own work book but have a couple of snagging issues. I am wanting to highlight any cell which is not empty except for cells with a question mark. I have used the formula: =AND(ISTEXT(A2), A2<>"?") but I have some instances where some cells with dates in them haven't been highlighted but others have. I have checked these cells and they have the same format as other highlighted cells3.4KViews0likes3CommentsRe: How to move entire row to another sheet based on cell value in Excel
LeonPavesic Can this be amended so the data on the original sheet is not deleted. I tried to amend by am not getting Compile error: Only comments may appear after End Sub, End Function or End Property and I'm lost!99KViews0likes1CommentMicrosoft Forms - Editing of associated Excel sheet
Hi, I have a form I use to track reports of defects. The excel sheet containing the responses is live and so updates as and when new responses are submitted.To track my actions to reports I have used a colour coding system i.e. defect raised for fix, duplicate etc etc. Historically when I made a change to the linked form the responses could not sync and I had to create a new sheet (this is when I came up with the colour coding system) my question is whether I can amend text in the excel sheet, specifically spelling mistakes, without the the sync failing againSolved3.5KViews0likes2CommentsConditional Formatting - Highlighting a row with multiple criteria
Hi, I'm trying to Highlight a row with multiple criteria. Normally I would use something along the lines of... =AND($A3="Yes",$B3="YES") But in this instance I need the second value to just be a non-blank cell and the formula for this doesn't seem compatible or I'm just not quite getting it. I need column N to read yes and column Q to be filled (with anything) to highlight the full row. Any help would be appreciated!!Solved3.7KViews0likes2Comments
Recent Blog Articles
No content to show