View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 1
Default Conditional Formatting

Hi, I just wondered if anyone knew if it was possible to copy and
paste a cells conditional formatting result with the actual formula
that it was based upon.

For example, Cell A1 has a CF that states that if the value is 5 or
less then the cell will have a have a cell background color of
yellow.

What I wold like to do is to keep the cell BG color as yellow but
remove the CF. Is that possible as I have a whole spreadsheet which
has CF which I would like to keep without the formulas that set the CF
in the first place.

Hope that makes sense lol

thanks in advance


steve

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus