Copying

[Anton]

I'm using an "If" function and then if true or false
taking information from another cell, I can get the
information but is it possible to bring the background
colour and font.

 

[Rog]

Anton, i don't quite understand what you're asking for -
do you want to change the colour and font of a cell
depending on the value in another cell? If so, look at
Conditional Formatting. If you want to check the colour
and font of a cell, you'll need a used defined function
for this.

Rgds

Rog