If conditions are met grey out cells, else reinstate originals

[julhs]

I want to temporarily re-format (grey out) all cells in a specific range when/if a condition is meet, so "=True".
The existing formatting for the range is a mixture of; fill colour, text colour BUT also Condition Formatting
But when/if the condition no longer "=TRUE", I want to reinstate the ORIGINAL formatting.
As a further note; I can’t just hide the relevant columns/rows, what I’m trying to do HAS to be achieved by formatting in some way.

 

[etaf]

conditional formatting - PUT your rule at the top of the list and then click on STOP IF TRUE
if the condition is met - it will grey and then stop and not look at any other rules
if its not true - it will go on the next rule

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

This will possibly enable a quicker and more accurate solution for you.

MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

You can also test to see if it works ok, in the "Test Here" forum.

Test Here

Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc. Threads in this forum are automatically deleted after no replies for seven (7) days

www.mrexcel.com

OR if you cannot get XL2BB to work, or have restrictions on your PC

then put the sample spreadsheet onto a share

I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed

Make sure you set any share or google to share to everyone

 

[julhs]

Thanks for response etaf
Your comments now make me believe I was over complicating this!!
I had thought of just doing this with additional CF rules as you suggested, but thought a VBA method would be easier.
I'll do what you suggested with CF rules and forget a Vba method.

 

[etaf]

VBA maybe the way - in the end , I dont provide VBA solutions on forums

 

[julhs]

Appreciate your point re VBA, that can turn out to be pain in the proverbial for likes of yourself.

But this is going to seem extremely lazy on my behalf, BUT it may avoid me having to come back to you later.
The condition to be met is; if a specific shape is NOT visible then apply greying format, is this possible with CF rule??
If so, what would be your suggestion be for the CF rule??
Otherwise it's back to a VBA method.

 

[etaf]

shape????
visible
not sure what that means

 

[julhs]

If ActiveSheet.shapes("btnBlaBla").Visible Then

Do something …………………

 

[etaf]

sorry thats VBA and i dont do VBA here
Sounds like you need VBA , otherwise no idea how to do shapes in conditional formatting
Maybe worth Asking a Moderator - VIA report - to delete all these posts and actually change the original post to point out its SHAPES & VISIBLE
Not just

when/if a condition is meet, so "=True".

 

[julhs]

Ok, I’ll see if I can get that done.
Thanks for your interest though.
Julhs