| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
conditional formatting for Error
Hi Friends
I want to format those Cells which contains any error. I have tried in conditional formatting with as Formula is =ISERROR, but it is not working. can any one help on this Thank you |
|
#2
|
|||
|
|||
|
Select your cells and use the cell referen ce of the first, such as
=ISERROR(A2) -- HTH RP (remove nothere from the email address if mailing direct) "krupesh" wrote in message ups.com... Hi Friends I want to format those Cells which contains any error. I have tried in conditional formatting with as Formula is =ISERROR, but it is not working. can any one help on this Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
