Finding cell formatting and returning value in another cell

[Aubs010]

Is there any way of finding the formatting of a cell and return a value in another cell?

e.g.
[tt]
IF Cell A1 is bold
THEN Cell B1 has a 1
[/tt]
or
[tt]
IF Cell A1 has a border
THEN Cell B1 has a 2
[/tt]

etc...

It cannot be with VB as the originator of the spreadsheet does not want VB/macros/etc used!

It would be very simple using VB!!

I can't see a way using the [tt]=CELL()[/tt] worksheet function.

Any help greatfully received.



Aubs

 

[SkipVought]

Aubs,

Ain't no way without VB or MANUAL.

Who's the boss?

Do you go in and tell your pilot before the flight, "I don't wanna fly over oceans, so figger out how to get from New York to London some other way!"

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[xlbo]

[ROFL]

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[Aubs010]

Thanks for your comment Skip...

It's not my boss, it's the person who originally developed the spreadsheet. They want it to not require VB as many people disable "macros" when the spreadsheet opens (also access XP by default disables them without warning!) and therefore making the workings of the spreadsheet unusable.

Unfortunately, the conditional formatting can only accept 3 formats and there are actually more than that needed so that's why I thought of using more than one cell to check the cell formatting.

Ok. Thanks for your input all the same.

Regards,





Aubs