Forum Discussion
Solved
need help with Excel conditional formatting
I am trying to create a task list where the header row names the individual tasks and the rows below each named column are empty and not formatted until, on any given date listed in the leftmost colu...
You could simply use the formula =B2="*", no need for IF.
Alternatively use the following rule for B2:P25:
- Select this range.
- Delete the existing rule.
- On the Home tab of the ribbon, select Conditional Formatting > New Rule...
- Select 'Format only cells that contain'.
- Leave the first drop down set to 'Cell Value'.
- Select 'equal to' from the second drop down.
- Enter the formula ="*" in the box next to it.
- Click Format...
- Specify the desired formatting.
- Click OK, then click OK again.
For the header row:
- Select B1:P1.
- B1 should be the active cell in the selection.
-
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
-
Select 'Use a formula to determine which cells to format'.
-
Enter the formula
=COUNTA(B$2:B$25)>0
-
Click Format...
- Apply the desired formatting.
-
Click OK, then click OK again.
Try this formula applied to B1:
=ISNUMBER(MATCH("*",B2:B35,0))
=ISNUMBER(MATCH("*",B2:B35,0))
