Forum Discussion
Solved
Conditional Formatting a Block of Cells Based on a Single Cell's Data
I have an excel workbook that I created for my employees monthly work schedules; in it I track their scheduled hours, actual worked hours, pay, overtime, etc. I have already created a drop down list...
- Hello,
A sample file would be needed to have a clear picture.
However, let say you have "meeting" and "no meeting" in cell J1 as List Data Validation dropdown and your range of data starts from A2:D100 and column A contains, for example, "Meeting" and "No meeting"
To highlight all the rows of data that has meeting based on column A:
1. Click on the New Rule
2. Use a formula...
3. Execute: $A2=$J$1
4. Apply desired format
5. Click OK.
Hello,
A sample file would be needed to have a clear picture.
However, let say you have "meeting" and "no meeting" in cell J1 as List Data Validation dropdown and your range of data starts from A2:D100 and column A contains, for example, "Meeting" and "No meeting"
To highlight all the rows of data that has meeting based on column A:
1. Click on the New Rule
2. Use a formula...
3. Execute: $A2=$J$1
4. Apply desired format
5. Click OK.
A sample file would be needed to have a clear picture.
However, let say you have "meeting" and "no meeting" in cell J1 as List Data Validation dropdown and your range of data starts from A2:D100 and column A contains, for example, "Meeting" and "No meeting"
To highlight all the rows of data that has meeting based on column A:
1. Click on the New Rule
2. Use a formula...
3. Execute: $A2=$J$1
4. Apply desired format
5. Click OK.