Tag Info

Hot answers tagged

2

Try this out. Highlight cell C3:D4 (as per example) and add conditional formatting with the following formula: =AND(ROW(C3)-2=DAY($A$1),COLUMN(C3)-2=MONTH($A$1)) I have tested this and it works as described so let me know if you have any problems. Note: this formula excludes year as a factor, so 1/1/2000 would highlight cell C3, as would 1/1/2015 Copy ...


2

Use relative formulas ($ or not) and set the Applies to range to the entire row. Just make sure that the first row in your formula and the first row in your Applies to are the same. (Screenshots show just some range example. Change to match your exact setup.)


1

You will need a macro in VBA, like this: Private Sub Worksheet_Change(ByVal Target As Range) Dim wk As Workbook Set wk = ThisWorkbook Dim ws As Worksheet Set ws = ActiveSheet CRow = Target.Row CColumn = Target.Column If CColumn = X Then CellValue = Cells(CRow, CColumn) Select Case CellValue Case Is < 0 Cells(CRow, ...


1

This is similar to Gary’s Student’s approach.  Define the following VBA function: Function MyRowHidden(ref As Range) MyRowHidden = Rows(ref.Row).Hidden End Function See How do I add VBA in MS Office? if you need help with that.  Now you can use MyRowHidden(cell) to check whether the row containing cell is hidden. The way I devised to solve the ...



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