Forum Discussion
Conditional formatting for rows with and without text
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).
3 Replies
=AND($A2="",$B2="")Is this the rule for conditional formatting you are looking for?
In the attached example conditional formatting is applied to range:
=$A$2:$B$24The gray cells change to white color as soon as data is entered.
- Hmmm... in the PDF you attached, it shows only the blank cells filled, not them switching back and forth.
In my spreadsheet, I have data through column K. I would like the colors to switch from gray to white (or white to gray) whenever new data is entered into column A and have it apply to the entire row. Does that make sense?Unfortunately i am not sure what is meant by switching back and forth. Maybe you want conditional formatting as in the attached file? If data is entered in A2 the row from column A to K is formatted white and gray in alternating order with this rule:
=$A2<>""Formatting is applied to range:
=$A$2:$A$25;$C$2:$C$25;$E$2:$E$25;$G$2:$G$25;$I$2:$I$25;$K$2:$K$25
