Tuesday, March 2, 2021

Cell Background Color ( Conditional formatting)

 as

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How do I find only strings that contain precisely "ABC" (upper case), but not those that contain "abc" or other upper/lower case combinations?

  How do I find only strings that contain precisely "ABC" (upper case), but not those that contain "abc" or other upper/...

  • Real Time Scenario
     1. Color of first and last bar same and other bar same 2. Divide the data into 2 sheets 3. Parameter Month/Quarter then in sheets Year-mont...
  • Filter/ Parameter hide based on Paramter selectoion
    Steps: 1. Create 2 Param1  and Param2. Param1 will be visible all the time the other will appear based on  selection on Param1. 2.Create bla...
  • Calculative field
    1. Some calculations comes under Diemensions and some under Measures 2. Some calculation we can change from Dimension to Measures and vice v...