User Profile
chwar750
Copper Contributor
Joined Jul 24, 2020
User Widgets
Recent Discussions
Conditional formatting across sheets
I have a sheet which manages the works of multiple budgets. One sheet provides an overview of the budget and the next show the various schemes attributed to the numerous budget codes. Currently I have to flip back and forth to see whether the budgets have available monies before progressing a scheme but with a high number of jobs each day this can be quite time consuming. I would like a formula to format the budget name cell in the second sheet (B:B) when the value in the available budget column (J:J) relative to the specific budget name (B:B) both in the first sheet, is showing as a negative figure.Solved130Views1like2CommentsHelp with Countif function (normal count unless another column states a certail text)
Hi all, I currently have a countif formula counting the number of projects staff members in my team are assigned to =COUNTIF('Work-Database'!E:E,"*Staff Member Name*") Ideally, I would like to add to this formula so that when column M states "Complete" this row/project isn't included in the count. I.e. were only counting live projects as opposed to completed projects. Is this possible? Thanks in advance!60Views0likes1Comment- 3.4KViews0likes1Comment
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.7KViews0likes3CommentsRe: 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!100KViews0likes1CommentMicrosoft 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 againSolved4.2KViews0likes2CommentsConditional 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!!Solved4.8KViews0likes2Comments
Recent Blog Articles
No content to show