Forum Discussion
Conditional Formatting - How do I get an entire row to change color based on any date being entered.
Perhaps if I tell you what I am trying to do it may make more sense. I use a scheduling application that doesn't carry over formatting when pasting into Excel. I did create a template that addresses column widths, cell height, freezing the first row, filtering, etc. But because the difference in rows between each heading varies for each weekly schedule I post into Excel, I cannot predict which rows will be a heading, therefore cannot "pre" format the rows.
Below is an example of a weekly schedule after pasting it into my template in Excel. What I would like Excel to do is:
1) If any date is present in the "A" column, make that row a certain color (the rows in this example are colored because I did it manually; when pasting from the scheduling tool, all rows are white.).
2) If any date is present in the "A" column, "clear contents" in columns J, K, L, and M. (in my screen shot those columns do not have any contents because I had already manually deleted them).
As variant you may apply the rule
to entire range. Or, if cells in column B for the rows with dates are always empty, we may use rule formula =ISNUMBER($A1)*($B1="") for more reliability.
Conditional formatting can't delete any content, it only may hide it. You may apply another rule with the same formula to columns J:M, but in formatting use for the font same color as for the background
Try at any empty cells, =ISNUMBER(A3) and =B3="", what each of them returns, TRUE or FALSE
Perhaps B3, B8, B16 etc. contain a space instead of being really empty? The rule should work if they are empty:
Try using =ISNUMBER($A1) as formula.
- SergeiBaklan had me try that one first and it didn't work either.
