search perticular result of conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have applied conditional format to very large range of data. Many cells are now having a perticular format as a result of these cells meeting the specified condition

How can I find those cells because find-format is not doing this task.
 
Harsh,

You need to test whether the cell meets the CF conditions. For instance, if
a CF condition is >6, then check which cells are >6. No automated function I
am afraid.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Harsh said:
I have applied conditional format to very large range of data. Many cells
Click to expand...
are now having a perticular format as a result of these cells meeting the
specified condition.
 
Back
Top