Conditional Formatting by row on a large selection in Excel
I'm trying to use conditional formatting to format a table of data. The functionality I need is basically if you put "done" in a cell at the end of the row, all of the text in the other cells to the left of it will be crossed out, and I want to make this true for all of the rows in the table using one formatting rule. I know I could do this by adding a new rule for each row, but there's obviously a quicker way, I'm just not sure which formula to use. I think I might need to use Visual Basic but I've got no clue how to use that so I'm lost. FYI I'm using the desktop version of Excel for Office 365.
I tried using what I found below but it didn't work: https://superuser.com/questions/38885/is-there-a-way-to-use-conditional-formatting-on-a-row-based-on-values-in-a-singl
No need for VBA. In this example:
use the formula =$F1="Done" for conditional formatting for Row 1. Apply it to cells =$A$1:$F$6. Set those for your needs, of course. Or apply it to =$A$1:$E$6 if you don't want the "Done" crossed out!
- Constrain a Specman list so it doesn't have identical values in consecutive elements
- How to type cast a list of uint to a list of vr_ahb_data in Specman?
- Static fields/methods in e
- What is the difference between deep_copy and gen keeping in Specman?
- Specman UVM: What is the difference between write_reg { .field == 2;}; and write_reg_fields?
- Does Specman support optional parameters to a method?
- Specman e: When colon equal sign ":=" should be used?
- Specman e: Is there a way to know how many values there is in an enumerated type?
- Specman e error: No match for file when using "for each line in file"
- How to run e file one by one? Not in parallel test
- Specman/e constraint (for each in) iteration
- Specman e: How driver's items queue can be locked from a sequence?
- Specman e: How to print variable's address?
- Specman e: "keep type .. is a" fails to refine the type of a field
- Specman soft select on variable, decimal vs. hexadecimal values
- Specman e: How to print a pointer to a struct?
- Specman e: Is there a way to print unit instance name?
- Specman e: simultaneous events error
- Specman e coverage: ignored values appear in the coverage statistics
- Specman e: How a sequence should be started when gen_and_start_main constrained to FALSE?
- Specman/e list of lists (multidimensional array)
- Does Specman e have struct constructor?
- Specman e: How the predefined sequence.item should be used?
- Specman e: define-as-computed macro error
- Specman e UVM: Why to inherit from uvm_* units?
- Specman e: A sequence drives its BFM also its MAIN was not defined in a test
- e HVL (IEEE 1647): expect expression fails unexpectedly
- Specman e subtyping: How to refer to FALSE value of conditional field in when/extend subtyping?
- e HVL (IEEE 1647): How to set 'X' value?
- Difference between declaring an event that is sensitive to a simple_port value and event_port