Forum Discussion
AUSTXCHICK
Jul 30, 2019Copper Contributor
Conditional formatting for entire row based on data in one cell
I need all cells in a row to highlight a certain color if the data in one cell contains a specific word. What I specifically want is for an entire row to turn grey if the status cell contains th...
- Jul 30, 2019
Hello
Assuming that D is the column containing the status cells, and you wish to apply conditional formatting to rows 1:50, here are the steps:
1. Select any cell in row 1
2. Go to 'Conditional Formatting>New Rule>Use a formula to determine which cells to format'
3. In the formula field paste =$D1="Shipped", set the required format and click 'OK'
4. Go to 'Conditional Formatting>Manage Rules' and locate the rule you have just created
5. In the field 'Applies to' paste '=$1:$50', or just select the required rows, starting from row 1, then click 'OK'.
If you type the word 'SHIPPED' in any cell of the column D (rows 1 to 50), the entire row will be conditionally formatted
Hope this helps
Yury
SergeiBaklan
May 31, 2021MVP
elgar65 , you are welcome
AYC94
Jul 19, 2021Copper Contributor
Hi, I want to highlight a certain similar reference numbers given for a customer, for example few customers might use the same reference number for an assessed criteria, appreciate if you could instruct me to apply conditional formatting to a single column to get the similar reference numbers to each other highlighted. (there could be few customers with similar reference numbers not just a specific one for all, I need to get such customers who might share the similar reference numbers highlighted). Thanks in advance.
- MCalhoun111Feb 21, 2022Copper Contributor
SergeiBaklan Is there a way to format the fill color of rows based on the information in Column A?
for example: I have a list of people in column A (lets say A1, A2, and A6) and dates I emailed them in column B (B1:B6). Now I have emailed some people multiple times so there are multiple rows beneath those names (but only info in column B and none in column A since that would be redundant to add the name again). So the names are in A1, A2, and A6, but dates in each of the B Columns.
I would like the filled colors to switch back and forth between gray and white each time a new name is entered into column A... while keeping the same filled color in the rows under the name without anything entered in column A.
See photo (I selected each row separately to fill but would like it to auto fill).
Thanks!
- emfields1840Oct 03, 2021Copper Contributor
I found this site helpful: https://www.extendoffice.com/documents/excel/2525-excel-highlight-row-if-cell-blank-contains-value-text.html#conditional_formatting
- SergeiBaklanJul 19, 2021MVP
Not sure I understood, is it possible to provide small sample file with manually indicated desired result?