Mar 01 2023 05:26 AM
I'm trying to highlight a range of cells in a row when data is entered in a particular cell in that row.
For example:
Select A1:D1 This is the range I want to change color
Select "Conditional Formatting"
Select "New Rule"
Style: Select "Classic"
Select "Use formula to determine which cells to format"
Enter formula: =D1>-.1 This is the cell that I want to change color of range A1:D1 when number >= -.1 is entered in D1.
Select "OK"
Result: Now when I enter data in D1only A1 changes color.
So the question becomes how to select a range that gets the conditional formatting.
See screen shot
Jack Ensor
Mar 01 2023 05:44 AM
Mar 01 2023 01:33 PM - edited Mar 01 2023 01:34 PM
@Hans Vogelaar Thanks to your answer, I was able to arrive at a solution. Here was my solution:
First you must select the entire range that you want involved. Normally in my case I don't know how many rows I'm going to need so it would be best to select enough that you think you will be covered. I will select a range covering 1000 rows.
Select A1:D1000 This is the range I want to change color
Select "Conditional Formatting"
Select "New Rule"
Style: Select "Classic"
Select "Use formula to determine which cells to format"
Enter formula: =$D1>0 This is the cell that I want to change color of range A1:D1 when a number >0 is entered in D1.
Select "OK"
Result:
If I enter a number >0 in any cell in column D up to D1000 it will format the corresponding row.
Thanks again!
Mar 02 2023 06:08 AM
Mar 03 2023 05:12 AM
Mar 03 2023 05:22 AM
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?