User Profile
ShishirKumar
Brass Contributor
Joined 6 years ago
User Widgets
Recent Discussions
- 966Views0likes0Comments
Re: formula en fechas
Hiitzhiarayuro You want to change the color the date field depending on current date. This can be achieved by using conditional formatting twice. One for highlighting for entries which are 1 month prior to current and second one for highlighting which are 2 months prior (Red). Have a look at enclosed file. Let me know if i have correctly understood your problem.1.1KViews1like1CommentRe: Trying to find a way to find and add text in front of found text.
Stephan475 Filter the rows with Yellow filled cells and in next column =CONCATENATE("Cell"&"D") and copy this for all rows. There you have your Yellow filled entries having D in the end of number in each cell.5.6KViews0likes0CommentsRe: move cell contents to another cell without affecting the formatting of either cell
HILazaroni You can achieve this by copying the original cell and then do a paste special (Alt + E S V) and again copying the original cell and do a format paste (ALT + E S T). I hope this will solve.1.4KViews0likes0CommentsRe: output a sum for variable precise limit
trevormorris You have define the set of rows with unique identifier in next column "F" such as number 1,2,3... So for ex. Row 54-172 can be tagged as 1 and then 200-214 as 2 and so on. After this use COUNTIFS($E$1:$E$576,">25",$F$1:$F$576,1) Same thing can be used for another set of rows having tag as 2 and so on. Make sure range is selected overall on all rows.1.1KViews0likes0Comments
Recent Blog Articles
No content to show