#conditional formatting

  1. K

    HOW TO MATCH DATA ONE WORKBOOK TO OTHER WORKBOOK & MATCHING DATA

    # 1st Condition : MATCH Data 1st "SHEET 1 WITH '"SHEET 2" # 2nd Condition : "SHEET 2" MATCH DATA with other Workbook "SHEET 1" like this BOTH CONDITION MATCH AFTER SHOW ME STATUS " YES / NO " in Worksheet 2 > SHEET 1
  2. K

    how to Apply Condition Formatting in Particular Cells At a time ??? (Rules : " <1 " Highlight Cell color to RED After Zero .)

  3. K

    Find particular text in Date

    # How to Find particular text in Date ?????? i try to find "2021" in this cell , If Condition is " OK" and if then may be change text like "2020" this condition show "Mistake"
  4. K

    Hide Row with Zero value with Entry

    Hide Row with Zero value with Entry
  5. R

    IF/THEN when pointint cell contains an existing formula

    cell a1 ...1 cell a 2 ...=a1+1 cell a 3 ...=a2+1 cell a 4 ...=a3+1 cell a 5 ...=a4+1 in cell b1 ... I want the results of IF cell A5 equals 5 then return a 1, if not then +1 the number like above. Im trying to loop 1-5 in each column based on the last cells info. Can you assist?
  6. P

    Pivot widths - format so width "sticks" as field order changes?

    Hi, Pivot is a report in tabular format, based on a TABLE. The TABLE has some columns of download data, and further columns calculating sums and logical messages. I extract the salient rows from the table for this stakeholder, using a tabular pivot format. There are around 15 "Row" columns in...
  7. B

    Conditional formatting not recognising text

    Hi I have a spreadsheet with about 1000 rows which contains the results of a trading marketplace (bidder details, buy bids, sell offers, prices, units bought/sold etc). I am trying to format 1 column (bid type) with lots of different colours depending on particular characteristics of the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top