Tag Info

Hot answers tagged

2

Let's suppose the letter (L/F) is in column B, then: Select the first row. Open Conditional Fomatting / New Rule. On type of formula, select "Use a formula" In the box put =$B1="F" On the button Format select the format that you want. With the row still selected use the Format Painter to copy this format to the other rows.


2

In Conditional Formatting, apply the formula =OR(B1="",MATCH("?",1:1,-1)>0) to column A. The MATCH portion will look for a question mark anywhere in any field in the row, not just a standalone question mark.


1

Under Conditional Formatting > New Rule > Use a formula to determine which cells to format: A rule to fill only M16 is =COUNTIFS(M3:Q12,M16)>0 applied to =M16. A rule to fill the range M16:Q40 is =COUNTIFS($M$3:$Q$12,M16)>0 applied to =$M$16:$Q$40.


1

You will need to use vba for this I believe. It used to be a real pain to get out conditional formatting colours even with vba but they have since added a new function. The below will copy the colour over in cells A1 to A3. This does not remove the conditional formatting so you will either have to do that manually or add something to the macro to do it. ...


1

Select the range and run this macro: Sub Main Dim oCurrentSelection As Variant Dim oRows As Variant Const nCellBackColor = 15132415 REM # "Blue gray" Dim i As Long oCurrentSelection = ThisComponent.getCurrentSelection() If oCurrentSelection.supportsService("com.sun.star.table.CellRange") Then oRows = ...


1

Using this formula =OR(B1="",A1:C1="?") gave me results that would seem to be what you are looking for:


1

I've done this before. I wish I could provide code for you but it was long ago and I don't have that code any longer. My data was set up with rows as records and columns as fields. I had specific rows to print at certain times, so I added a column to my sheet that I would put a letter into as a label for when to print. i.e. S for Sales dept, A for Accounting ...


1

(1) Copy the column you want to format to an empty worksheet (2) Select the column, and then choose "Remove Duplicates" from the Data ribbon (3) To the right of your unique list of values or strings, make a unique list of numbers. For instance, if you have 6 categories to color, the second column could just be 1-6. This is your lookup table. (4) In a new ...



Only top voted, non community-wiki answers of a minimum length are eligible