Excel Conditional Formatting already lets you format cells based on the value of those cells or the value of the formulas in those cells (see our conditional formatting tutorial for more details ...

You can set up conditional formatting in Excel for dates. We have included detailed examples you can try while reading the guide.

To do that, click Conditional Formatting > New Rule. Select Use formula to determine which cells to format, and under Format value where this formula is true, enter the following formula: ...

In general, formulas in Google Sheets will contextually update themselves when you copy from one cell and paste to another. But that doesn't happen with formulas used in conditional formatting. So in ...

Select cell B2 and choose Conditional Formatting from the Format menu. When applying this to your own worksheet, select the first value in the column (not the column’s label text).

In our first tutorial on Google Sheets, we looked at extending the software's default conditional formatting options through the use of formulas. That solution is good for a limited range of dates, ...

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.