Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to do some "Conditional Formatting" of a range of cells if any
cell in that range is focused on. example, assuming I've built a payroll spreadsheet, and I'm using rows 2 though 7, (columns A through M). A2:A7 the list of employee names B2:B7 the emploee pay rate, C2:C7 the number of hours the employee worked, etc., etc until M2:M7 which shows the employees NET wages. When I focus on any cell within a row, (click in a cell), I want to set up conditional formatting that will effect all the cells within that row. (Basically, if I focus in D4, I want cells A4-M4 (the entire row) to have a solid green pattern with BOLD white text. Then, IF I click in L5, I want A4-M4 to back to its normal formatting and row A5-M5 to assume the solid green pattern with BOLD white text.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Click inside both Spreadsheet and VBE - Back and forth | Excel Discussion (Misc queries) | |||
How do I get the focus on a check box? | New Users to Excel | |||
Spell Check an Unlocked Cell in a Protected Spreadsheet | Excel Worksheet Functions | |||
How do I add a check mark in a cell in a spreadsheet in Excel? | Excel Discussion (Misc queries) | |||
Looking for inside sale compensation spreadsheet | Excel Discussion (Misc queries) |