Excel Tips--conditional formatting for a reporter a cell/whole row

Here I mostly use WPS Excel to do the test with office2003 Excel

One, label a cell (first select the data source you want to label)

• Using WPS

1, WPS itself with the highlighting function

2, using format--conditional format

If you have a number, you can select cell value directly or use a formula such as a cell that displays a marker >50

and match some pattern.

• Use Office Excel as using 2 in WPS

Second, to meet a certain condition mark the whole line, using the format----conditional format formula

Summary: We can use the =countif (,) pattern, mark the whole row or a cell difference in whether the $A 1 with $

Excel Tips--conditional formatting for a reporter a cell/whole row