Check Value Then Delete From Different Sheet

[Rickbus]

Hello Guys,

Am new to this and could spend hours working it out, but i believe its simple i just don't have the time.

What i have is two sheets.
Raw Data
Percentages

I take the values from raw data to work out a percentage on the percentage sheet.

I now want to code a macro where by if the value in a specified cell range in this case
B3:DY55
is less than 1 I want to delete the value in that cell and make the background red, but also do the same to the same sell but on Sheet: RawData.

Eg,
If J36 is 0.85 it will delete the value of that to Zero back background red and then also delete the value of J36 on RawData tab and make the background red.

Is this straight forward?
Please tell me it is.

[Richard Buttrey]

Hi,

Can't you just add a conditional IF() test to the formulae in the ranges you're interested in and return a zero value if <1. Then use conditional formatting to set the background colour.

If you want further help then it would be useful if you could upload an example workbook.

Regards

[Rickbus]

That would work for the percentages sheet Richard, but then how would i get it to delete the matching cell from the RawData tab?
As i can't really have formulas on the RawData tab because thats where i paste in the raw data.

[Richard Buttrey]

Hi,

You can still use formulas in the conditional formats for cells in the raw data sheet. Please note I am not saying add formulas to the raw data cells, but to the formula box in the conditional formats functionality. When you set conditional formats you have a choice of whether you use the cell value itself, or use the 'Formula Is' option. If you use the formula is option then simply create a formula which refers to the cells on the percentages sheet.

Typically in the cond formats of cell on Raw data this would be

Please Login or Register  to view this content.

with the appropriate format set.

Just remember when you paste data to the Raw data that you use Paste Special Values otherwise you will destroy any CFs you have set up.

Regards