Excel question1

[djeipa]

Hello, can you tell me hjow to highlight a cell with IF ?
eg IF(A1>100,HIGHLIGHT,NotHIGHLIGHT) <<<<<< somethin like that ????

Thank you

 

[djeipa]

Highlight,
I mean to change the color of a cell automaticily, thanks

 

[Dr Transport]

Look in the format cell functions.....

 

[djeipa]

Look in the format cell functions.....

Thank you doc, it works perfectly
I am thinking bout how to change even the color of my text in the cell, is there any way taht can do with IF??? thanks guru