Conditional Format a Cell Containing a Formula

[Steve 1962]

Hi

Is there a conditional formatting rule I can write that highlights a cell if it contains a formula. Don't need conditional formatting if the value is inputted.

Thanks

 

[Cubist]

Try:

=ISFORMULA(A1)

 

[Steve 1962]

Thanks Cubist. Works fine.

 

[Son Raphon]

Dear all, I have a table that separated item by category. I want to set bold text on last cell of row by using conditional formatting.
Example: I have Col Item name and Col Amount.
Item Name, Amount
A 100
A 200,
A 300
B 50
B 100

I want to set bold on col amount with 300 for category A.
And set bold on col amount with 100 for category B.

Anyone, could you guide and help me?

 

[Cubist]

Dear all, I have a table that separated item by category. I want to set bold text on last cell of row by using conditional formatting.
Example: I have Col Item name and Col Amount.
Item Name, Amount
A 100
A 200,
A 300
B 50
B 100

I want to set bold on col amount with 300 for category A.
And set bold on col amount with 100 for category B.

Anyone, could you guide and help me?

Yes, we can help but please start a new thread as this is not related to the original question of the OP.

 

[Son Raphon]

Yes, we can help but please start a new thread as this is not related to the original question of the OP.

I posted already. Thank you