Auto format next up rows???

[Trp404]

Have another question my friends…
I’ve got seven titled data columns
-Sorte Date
-Total Flight Time
-On Station Time
-EnRoute Time
-Total Targets
-Targets Per Total Hour
-Targets On Station Per Hour
I’m freezing the Row with the above data list …
My question:
Considering the number of entries below these will be irregular in that there is no way to know how many entries there will be, is there a way to do something like have a “running or auto formatting” formula to format the next row each time an entry is entered.
The only formulas I’ll have running will be : (which I can do)
Total Time – On Station Time= EnRoute Time
Avg sum of Total Targets / Total Hours and
Total Targets / On Station Time
Hope I’ve not been too confusing.
Thank you

 

[venkat1926]

what is your conditional foramtting formula for each column. you can add one more condition if cell<>"" so that blank data will not be formatted. you can copy the format to the whole column(s)

I hope my answer also is not confusing.