Forum Discussion
Conditional Formatting tasks by color
See the attached version. I added an extra rule to format tasks that have been completed but late.
See the attached version. I added an extra rule to format tasks that have been completed but late.
Select the range with conditional formatting.
On the Home tab of the ribbon, click Conditional Formatting > Manage Rules...
Click each of the rules in turn and click Edit to view the formula used.
You'll see that the rules refer to the cells in the first row of the range: C4 and D4 (plus the cell that contains the date).
What you state is correct for Windows with Excel 365. The problem is there is not current mechanism to set OR modify conditional formatting on an iPad, this from Microsoft support. I’m trying too ring their chime to get this feature added to Excel 365 for iPad (iOS). What is odd I’d that I set up conditional formatting on my PC and save the file to the iCloud Drive. When I open that file up on my iPad the existing conditional formatting from the PC still does its thing on my iPod. This tells me that Microsoft has half the problem solved for use on the iPad, they only need to add the UI menus and software to be able to set up, or modify existing, rules . Please listen Microsoft. This is a needed feature for your Excel 365 on the iPad
- The limited functionality of Excel on an iPad, as a 365 user, is infuriating. And most of the limitations are YEARS old!! I can’t believe how basic it is 😞
