Differentiating between a Formula and Hard Entered (Static) Data - Excel

[Bailey_Stiles_Epiroc]

I have the problem of trying to conditional format a cell based upon whether the contents of each cell are hard entered (static) data or if there is a formula in the cell. 

Example of this is when I am calculating dates and I want to actualise this information:

	1	2	3	4
A	Item ID	Leaving Date	Duration	Arrival Date
B	Item A	18-Oct-21	14	01-Nov-21
C	Item B	01-Aug-21	23	24-Aug-21

Cell contents:

	1	2	3	4
A	Item ID	Leaving Date	Duration	Arrival Date
B	Item A	18-Oct-21	14	=B2+B3
C	Item B	01-Aug-21	23	24-Aug-21

I want cells B2, C2 and C4 to be highlighted by conditional formatting as they are hard entered, however, due to the fact B4 is a formula calculated by leaving date + expected duration then it shouldn't be highlighted until actualised.

Any further information required please advise, thanks.

Kind regards,

Bailey

[#2]

@Bailey_Stiles_Epiroc 

I don't understand what you want (and your tables have switched the row numbers and column letters), but you could create rules of type 'Use a formula to determine which cells to format'. In the formula for the rule, you can use the ISFORMULA function.

ISFORMULA(B2) will return TRUE if B2 contains a formula and FALSE if it doesn't.